How to repair corrupted mysql table?

Hello,

im having command to check and repair (at least i believe) all mysql tables in all databases:

Quote:

mysqlcheck -u root -p*** --all-databases --check --auto-repair -F -C

but on my website i got error message an table is crashed, so i run above command but it just returned like:

Quote:

myusername_mydbname.prefix_tablename

warning : Table is marked as crashed

error : Found 10150 keys of 10151

error : Corrupt

So i want to ask how i can repair that table using mysqlcheck or any other linux command?

Its possible to do via phpmyadmin but i need linux command.

Thx

Continue reading...