VPS侦探论坛

 找回密码
 注册
查看: 288|回复: 1

lnmp1.7 升级mysql 5.7 到8.0.22后老数据没有导入

[复制链接]
发表于 2020-12-18 14:31:19 | 显示全部楼层 |阅读模式



今天试着用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: [Warning] 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.

请问这个应该怎么弄?

谢谢
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2020-12-18 20:52:20 | 显示全部楼层


你可以按照升级教程恢复原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  保存,再升级
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2021-1-26 00:21 , Processed in 0.049851 second(s), 26 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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