修复MYSQL数据库表结构

水根LP49

已于 2024-01-15 14:18:41 修改

阅读量340

点赞数 10

文章标签：数据库 mysql adb

于 2024-01-14 12:47:48 首次发布

本文链接：https://blog.csdn.net/weixin_42821740/article/details/135581991

版权

文章讨论了MySQL数据库中出现的表结构损坏问题，表现为多条错误日志提示表已标记为崩溃并需要修复。提供了解决方案，即使用myisamchk工具进行安全恢复，并建议修复后检查表结构是否恢复完好。

摘要由CSDN通过智能技术生成

核查/var/adm/messages日志,如有发现出现这样MYSQL表结构报错的信息：

May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:30:55 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/tsi_mr_crxlvquu_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:35:53 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_cferrxqu_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:35:54 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_cferrxqu_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:35:54 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_crxlvqud_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:35:54 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_crxlvquu_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:36:03 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_crxlvquu_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:36:04 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_crxlvqud_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:40:47 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_cferrxqu_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:40:47 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_crxlvqud_trx_663' is marked as crashed and should be repaired
May 6 08:53:33 hbniosserver2 mysqld[698]: [ID 702911 daemon.error] 100506 8:40:47 [ERROR] /opt/dc_mysql/bin/mysqld: Table './mddb/
tsi_mr_crxlvquu_trx_663' is marked as crashed and should be repaired

可能是由于数据库该表采集数据量太大造成MYSQL数据库表结构损坏，报错日志出现这样的问题是可以修复。
修复语句需要在MYSQL用户下执行：
/opt/dc_mysql/bin/myisamchk --safe-recover --force /opt/dc_mysql/var/mddb/tsi_mr_crxlvquu_trx_663

修复完后查看MYSQ数据库desc tsi_mr_crxlvquu_trx_663看下修复的MYSQL表结构是否恢复。