MYSQL 8.0 - 不支持的重做日志格式 [英] MYSQL 8.0 - unsupported redo log format

问题描述

我最近更新了位于我的 xampp 文件夹下的 mysql，我收到了以下错误，从日志文件中报告:

<前>2018-04-19T12:59:19.667059Z 0 [系统] [MY-010116] [服务器] C:\xampp\mysql\bin\mysqld.exe (mysqld 8.0.11) 作为进程 9324 开始2018-04-19T12:59:20.025280Z 1 [错误] [MY-013090] [InnoDB] InnoDB:不支持的重做日志格式 (0).重做日志是在 MySQL 5.7.9 之前创建的2018-04-19T12:59:20.026140Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB:插件初始化因错误通用错误而中止.2018-04-19T12:59:20.229069Z 1 [ERROR] [MY-011013] [Server] 无法初始化 DD 存储引擎.2018-04-19T12:59:20.230803Z 0 [ERROR] [MY-010020] [Server] 数据字典初始化失败.2018-04-19T12:59:20.231371Z 0 [错误] [MY-010119] [服务器] 中止2018-04-19T12:59:20.233136Z 0 [系统] [MY-010910] [服务器] C:\xampp\mysql\bin\mysqld.exe:关闭完成 (mysqld 8.0.11) MySQL 社区服务器 - GPL.

有人告诉我，如果更新您的 mysql，您应该注释掉 my.ini 中已弃用的配置，但我不知道要注释掉什么，所以我保持原样.

知道是什么原因造成的吗?

解决方案

如果您已经安装了 MySQL 并且没有使用

执行慢速关机

innodb_fast_shutdown

标记，只需转到您的 MySQL 目录

/var/lib/mysql/

并删除日志文件(不要这样做如果您需要数据库中的表数据直到您已经备份了您的数据库):

ib_logfile0ib_logfile1

如果您再次需要它们，请先将它们备份.

I have recently updated mysql that was located under my xampp folder, and i've got the following errors, reporting from the log file :

2018-04-19T12:59:19.667059Z 0 [System] [MY-010116] [Server] C:\xampp\mysql\bin\mysqld.exe (mysqld 8.0.11) starting as process 9324
2018-04-19T12:59:20.025280Z 1 [ERROR] [MY-013090] [InnoDB] InnoDB: Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
2018-04-19T12:59:20.026140Z 1 [ERROR] [MY-012930] [InnoDB] InnoDB: Plugin initialization aborted with error Generic error.
2018-04-19T12:59:20.229069Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2018-04-19T12:59:20.230803Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2018-04-19T12:59:20.231371Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-04-19T12:59:20.233136Z 0 [System] [MY-010910] [Server] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11)  MySQL Community Server - GPL.

I have been told if updating your mysql, you should comment out the deprecated configs that are located in your my.ini, but i had no idea what to comment out, so i left it as it is.

Any idea what causes this?

解决方案

If you have already installed MySQL and did not perform a slow shutdown using the

innodb_fast_shutdown

Flag, simply go to your MySQL directory

/var/lib/mysql/

And remove the log files (Do not do this if you need the table data in your database until you have backed up your database):

ib_logfile0 ib_logfile1

Back them up before if you need them again.

这篇关于MYSQL 8.0 - 不支持的重做日志格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！