wordpress table: Table is marked as crashed and last repair failed

 Run the following command:


ubuntu@ip:/home$ mysql -u user -p

Enter password:

mysql> connect database_name

Connection id:    somenumber

Current database: database


mysql> select * from table_name limit 1;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

Connection id:    1120568

Current database: database



mysql> repair table table_name;

+-----------------------+--------+----------+----------+

| Table                 | Op     | Msg_type | Msg_text |

+-----------------------+--------+----------+----------+

| database.table_name | repair | status   | OK       |

+-----------------------+--------+----------+----------+

1 row in set (3.56 sec)


mysql> select * from table_name limit 1;


mysql> exit

Bye

Post a Comment

0 Comments