[Sysadmin] Fw: WARNING: mysqlcheck has found corrupt tables

[Eduardo Kienetz]

On Tue, Nov 4, 2008 at 10:50 PM, David Kaufman <david.kaufman at gmail.com> wrote:
> wikidb.searchindex
> warning  : Table is marked as crashed
>
>  Improperly closed tables are also reported if clients are accessing
>  the tables *now*. A list of current connections is below.
>
> +----+------------------+-----------+----+---------+------+-------+------------------+
> | Id | User             | Host      | db | Command | Time | State | Info
> |
> +----+------------------+-----------+----+---------+------+-------+------------------+
> | 5  | debian-sys-maint | localhost |    | Query   | 0    |       | show
> processlist |
> +----+------------------+-----------+----+---------+------+-------+------------------+
> Uptime: 4  Threads: 1  Questions: 451  Slow queries: 0  Opens: 415  Flush
> tables: 1  Open tables: 64  Queries per second avg: 112.750

Did you try "repair table xxx" ?
Or: mysqlcheck --user=[username] --password=[pwd] --repair -A

If it doesn't work, stop mysql and restart it, then try again.

-- 
Eduardo Bacchi Kienetz