MYSQL table is crashed

来源:互联网 发布:战地4龙之谷灯笼算法 编辑:程序博客网 时间:2024/05/16 05:52
[root@localhost ~]# mysqldump -u root -p'mysql2012' server_balance_load|gzip>servre_balance_load.sql.gz

mysqldump: Got error: 145: Table './server_balance_load/customer_info' is marked as crashed and should be repaired when using LOCK TABLES


进入数据库对该表进行检测 mysql> check tables customer_info;

 修复表:mysql>repair table customer_info;

再次检测: mysql> check tables customer_info;

0 0