How to repair corrupted mysql table?

  • Thread starter Thread starter postcd
  • Start date Start date
P

postcd

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...
 
Back
Top