LMLPHP后院

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

maybe yes 发表于 2017-07-08 09:05

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-11-19 05:38:11 1511041091 0.005052