【待反馈】求助，mysql升级到最新后，数据库表坏了

宝塔后台根据提示升级MySQL 到最新版5.6.51后，数据库表提示1146table doesnt exist，在phpmyadmin内也是打不开的


mysql管理里面的的部分日志：
gh the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2021-12-07 11:07:06 2516 [Warning] InnoDB: Cannot open table w_wenhua/ims_ft_lesson_aliyun_upload from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2021-12-07 11:07:06 2516 [Warning] InnoDB: Cannot open table w_wenhua/ims_ft_lesson_article from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2021-12-07 11:07:06 2516 [Warning] InnoDB: Cannot open table w_wenhua/ims_ft_lesson_attribute from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2021-12-07 11:07:06 2516 [Warning] InnoDB: Cannot open table w_wenhua/ims_ft_lesson_banner from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.



能看到表，但是打不开，提示数据库不存在

您好，您更新前或者之前有没有做完整的数据库备份？修改文件后缀名是无法解决这个问题的

近期数据库没备份，不过找到一个早期的备份是完整的。恢复以前数据库备份文件后，网站正常，但是后面几个月还添加不少数据。
恢复以前完整数据库后，发现有问题的数据库是没有索引。

大炮运维V587 发表于 2021-12-7 14:35
您好，您更新前或者之前有没有做完整的数据库备份？修改文件后缀名是无法解决这个问题的 ...

mysql升级后，能否降级吗。

kuainiunet 发表于 2021-12-7 15:57
mysql升级后，能否降级吗。

升级数据库请在网站访问量极少的时候升级，否则肯定会造成数据表损坏，一但表损坏降级也无法解决问题