mysql表修复

1.1命令myisamchk(必须停掉mysql服务,或者所操作的表处于不活动状态)。

    [mysql@webdb01 ~]$myisamchk -r mytable.MYI
    myisamchk [OPTIONS] tables[.MYI]
      -o, --safe-recover  Uses old recovery method; Slower than '-r' but can
                          handle a couple of cases where '-r' reports that it
                          can't fix the data file.

1.2命令mysqlcheck(mysql服务可以处于运行状态)。

    [mysql@webdb01 ~]$mysqlcheck mydatabase mytable
    Usage:
    mysqlcheck [OPTIONS] database [tables]
    OR mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...]
    OR mysqlcheck [OPTIONS] --all-databases


2.修复表。

    mysql> REPAIR TABLE mytable;