How to repair corrupted mysql table?

Hello,

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

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

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

 

What engine is it using?

 

There you go:
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

 

Shagoon: that not help. i already read.

 

Assuming this is MyISAM

myisamchk -r -v -f --sort_buffer_size=128M --key_buffer_size=128M /path/to/your/base/table.MYI

 

Assuming. As he didn't answer my question, I assume he doesn't know what is meant by engine. :-D

I would be tempted to do a -q -r first though. Or just a myisamchk on the database file to get an overview of what is wrong. Do another after the repair too.

 

Im not sure what is is. This is vbulletin wordpress and similar CMS.

Im quoting:

I assume i would need a bash script to repair only crashed tables, because --auto-repair dont works and --repair works but on all tables even not crashed which i dont need.
But i did not found any bash script that do this. not capable to make it myself, i would spend around 24 hours doing it

 

Regarding engines:
http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html

Firstly, before doing anything I would recommend backing up the files, so if it does get screwed you would have backups to fall back to.

Secondly, figure out what storage engine you're using. Then before even repairing do an analysis to identify what is corrupt and take steps that are more suitable for that particular engine.

 

Have you tried this command too : mysqlcheck -u root -p --auto-repair --check --optimize --all-databases ? Please check & comment.

 

Hello

If you have phpmyadmin access you have a repair function integrated.

Regards
Christophe