How to repair corrupted mysql table?

[postcd]

Hello,

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

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:

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

 

[arochester]

Have you tried this?

If you must rebuild a table because a table checking operation indicates that the table is corrupt or needs an upgrade, you can use REPAIR TABLE if that statement supports the table's storage engine. For example, to repair a MyISAM table, use this statement:

mysql> REPAIR TABLE t1;

- https://dev.mysql.com/doc/refman/5.0/en/rebuilding-tables.html

 

[postcd]

as You can see, im using "--auto-repair " operator to the "mysqlcheck" command.
How can i add yours mentioned repair command into my command so its repaired automatically when table is corupt?

 

[laurentv]

if MyISAM:
stop mysql and launch :
myisamchk -r -v -f --sort_buffer_size=128M --key_buffer_size=128M /path/to/your/base/table.MYI

 

[taiavatar]

im command type --auto-repair