Log in

View Full Version : Table post crashed, now what?


dutchbb
03-30-2015, 11:48 AM
Already tried repairing it in the ACP, this results in everything freezing up. How to fix this?

ForceHSS
03-30-2015, 11:53 AM
Try a manual repair try from admincp or phpMyAdmin

Dave
03-30-2015, 11:53 AM
You should run the repair command from the command line on your server instead of doing it through PHPMyAdmin.

Refer to http://www.codero.com/knowledge-base/questions/274/How+to+check+and+repair+MySQL+database+tables


Log into the MySql command line tool using the following command and then enter the MySql password.

# mysql -u username -p databasename
# password: ********
mysql> check table tablename;
mysql> repair table tablename;

After the table has been repaired, type 'exit' to quit the command line tool.

mysql> exit
bye