找回密码
 注册

failure when upgrading MySQL from 5.7 to 8.0

php 发表于 2018/4/26 22:41 | 显示全部楼层 |阅读模式
InnoDB: Upgrade after a crash is not supported. This redo log was created with MySQL 5.7.21. Please follow the instructions at ....
InnoDB: Plugin initialization aborted with error Generic error.
Failed to initialize DD Storage Engine.
Data Dictionary initialization failed.

You may need to first export your databases using the mysqldum utility and then reintialize the MySQL installation and reinstall the newer MySQL service.

0. Stop the MySQL service, and then delete all files and sub-folders under the data directory
1. Run the commandline "mysqld --console --initialized" to initialize the data directory
2. Run the commandline "mysqld --install MySQL" to install the service.
3. Start the MySQL service
4. Import databases that were exported

In fact, when on Windows operating systems, if you didn't uninstall the MySQL service before reinializing the data directory, you don't have to reinstall the MySQL service. Don't export and import the system database named MySQL! And you should never create your own table under the system database MySQL to avoid data losing.

手机版|轻松E站

轻松E站

快速回复 返回顶部 返回列表