MYSQL修复mysqlcheck

适用版本
MySQL 5.6 及部分MYSQL 5.5 及以上版本
语法

shell> mysqlcheck [options] db_name [tbl_name ...]
shell> mysqlcheck [options] --databases db_name ...
shell> mysqlcheck [options] --all-databases

常用参数options

--all-databases	Check all tables in all databases
--all-in-1	Execute a single statement for each database that names all the tables from that database			
--analyze	Analyze the tables
--repair	Perform a repair that can fix almost anything except unique keys that are not unique

repair

--repair --quick 尝试快速修复
--repair 正常修复(除非快速修复失败)
--repair --force 强行修复
点赞