Repair MySQL Database
Warning: file_get_contents(http://ecs.amazonaws.com/onca/xml?Service=AWSECommerceService&AWSAccessKeyId=1TJ8QTQ6ZFCVAJ3X1T02&AssociateTag=ii0c3-20&Operation=ItemSearch&SearchIndex=Books&ResponseGroup=Small,Images&Keywords=mysql) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 400 Bad Request in /home/manusia2/public_html/wp-content/plugins/amazonfeed/php/amazonfeed.class.php on line 271
Here is some info how to repair all mysql database on your server with simple command.
The mysql database server needs to be running to do any of these checks. Log in as ‘root’ via SSH and:
Shows you if any need repair:
myisamchk –check /var/lib/mysql/*/*.MYI
Then try ’safe-recover’ first:
myisamchk –safe-recover /var/lib/mysql/*/*.MYI
and, if neither that nor this works:
myisamchk –recover /var/lib/mysql/*/*.MYI
Then use the ‘force’ flag:
myisamchk –safe-recover –extend-check –force /var/lib/mysql/*/*.MYI
or:
myisamchk –recover –extend-check –force /var/lib/mysql/*/*.MYI
also you can use the following commands :
mysqlcheck –all-databases -r # repair databases
mysqlcheck –all-databases -a #analyze databases
mysqlcheck –all-databases -o #optimize databases
hope it will help 