dongpa9277
2018-04-19 13:12
浏览 330
已采纳

MYSQL 8.0 - 不支持的重做日志格式

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?

图片转代码服务由CSDN问答提供 功能建议

我最近更新了位于我的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 [ERROR] [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 [错误] [MY-011013] [服务器]无法初始化DD存储引擎。
2018-04-19T12:59:20.230803Z 0 [错误] [MY-010020] [服务器]数据字典初始化失败 。
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中有一些已弃用的配置,但我不知道要注释掉什么,所以我把它保留原样。

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

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douyan9417 2018-05-17 21:52
    已采纳

    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.

    已采纳该答案
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题