REPAIR [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name[,tbl_name...] [QUICK] [EXTENDED] [USE_FRM]
REPAIR TABLE works only on MyISAM tables and is the same as running myisamchk -r table_name on the table. Normally you should never have to run this command, but if disaster strikes you are very likely to get back all your data from a MyISAM table with REPAIR TABLE. If your tables get corrupted a lot, you should try to find the reason for it, to eliminate the need to use REPAIR TABLEgood luck
REPAIR TABLE works only on MyISAM tables and is the same as running myisamchk -r table_name on the table. Normally you should never have to run this command, but if disaster strikes you are very likely to get back all your data from a MyISAM table with REPAIR TABLE. If your tables get corrupted a lot, you should try to find the reason for it, to eliminate the need to use REPAIR TABLEgood luck
解决方案 »
- #1690 - BIGINT UNSIGNED value is out of range in .... INT(11) UNSIGNED
- 求mysql left join 限制条数的语句
- 求一个使用mysql进行小计的语句
- 高手指教:合并两个相关表,求一mysql 语句
- mysql字符集问题
- 急!请教高手:数据库系统时间的添加
- 求推荐一款优秀的开源的数据库管理工具,可以支持mysql、oracle、sqlserver、db2等。
- mysql数据库中,查询a表的a2字段中是否包含1或2或3,语句应该怎样写?知道的大大指点下
- MySQL 主从热备问题
- 2PC协议在mysql中有应用到吗
- 如何用mywql来保存图片等其它非字符,数字的东西
- 请问,我们有一台LINUX服务器,上面是MYSQL和PHP,为什么每次一做备份就要把WWW服务停掉呢?
2. \mysql\bin\myisamchk -r xxxx.MYI