LMLPHP后院

is marked as crashed and last (automatic?) repair failed技术

MYSQL MyISAM 数据表出现问题,提示 Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed。

修复数据表操作:

  • 1. service mysqld stop;
  • 2. cd /var/lib/mysql/db_name/
  • 3. myisamchk -r table_name.MYI (修复单张数据表), myisamchk -r *.MYI (修复所有数据表)
  • 4. mysqlcheck -o -r db_name -p

查看 warning 信息:

mysql> show warnings;
LMLPHP,可爱滴WEB开发框架

2017-07-27 04:35:39 1501101338 0.008977