mysql - 找不到 Homebrew MariaDB 10.4.13 - 强制更新到 10.5.5，现在我无法启动数据库

Question

我无法使用brew找到MariaDB版本10.4.13。通过卸载和安装(严重错误)Homebrew 重新安装后，将我的版本升级到 10.5.5

现在我收到以下错误:

020-08-14 20:33:07 0 [Note] InnoDB: Uses event mutexes

2020-08-14 20:33:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2020-08-14 20:33:07 0 [Note] InnoDB: Number of pools: 1

2020-08-14 20:33:07 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2020-08-14 20:33:07 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728

2020-08-14 20:33:07 0 [Note] InnoDB: Completed initialization of buffer pool

2020-08-14 20:33:07 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.13.

2020-08-14 20:33:07 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

2020-08-14 20:33:07 0 [Note] InnoDB: Starting shutdown...

2020-08-14 20:33:07 0 [ERROR] Plugin 'InnoDB' init function returned error.

2020-08-14 20:33:07 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2020-08-14 20:33:07 0 [Note] Plugin 'FEEDBACK' is disabled.

2020-08-14 20:33:07 0 [ERROR] Unknown/unsupported storage engine: InnoDB

2020-08-14 20:33:07 0 [ERROR] Aborting

任何帮助将不胜感激。我的数据目录仍然位于/var/log/mysql 之外的某个位置。

Answer 1

我发现解决这个问题的唯一方法是通过重命名它们来备份我的 /var/lib/mysql 和 /var/lib/mariadb 目录，然后将它们创建为空目录。我知道这对很多人来说不是一个选择，如果您仍在开发中并正在处理种子数据，那么这应该适合您。

有人讨论过从这些目录中删除日志文件，从而保留数据，尽管我还没有尝试过。

据报道已删除日志文件以解决此问题:

/var/lib/mysqld/ib_logfile0
/var/lib/mysql/ib_logfile1
/var/lib/mysql/aria_log_control

引用自 https://github.com/laradock/laradock/issues/93