View Single Post
Old 02-24-2007, 03:50 PM  
StuartD
Sofa King Band
 
StuartD's Avatar
 
Join Date: Jul 2002
Location: Outside the box
Posts: 29,903
Quote:
Originally Posted by darling2 View Post
you can use the repair table command.

1. log into your server via ssh.
2. then use the mysql client to connect to the database like:
mysql -uYourUserNAme -pYourPassword YourDatabasename

3. issue this command for every broken table:
repair table YourTableName;

After this all your tables will be fixed and you can export them
Can also be done in phpMyAdmin pretty easily if that's on there.
StuartD is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote