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
0 Comments