lnmp1.7 升级mysql 5.7 到8.0.22后老数据没有导入
今天试着用lnmp1.7把mysql5.7升级到了8.0.22升级成功后发现原来的数据库都没有了，只有information_schema mysql performance_schema sys这四个系统库了。
升级日志里面提示
Restore backup databases...
ERROR 3554 (HY000) at line 276: Access to system table 'mysql.innodb_index_stats' is rejected.
Repair databases...
mysql_upgrade: Using a password on the command line interface can be insecure.
The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.
The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.
请问这个应该怎么弄？
谢谢
你可以按照升级教程恢复原mysql版本
可以尝试编辑lnmp安装包目录下的 include/upgrade_mysql.sh 查找 /usr/local/mysql/bin/mysql --defaults-file=~/.my.cnf 替换为 /usr/local/mysql/bin/mysql --defaults-file=~/.my.cnf -f保存，再升级
页:
[1]