Repair all database in mysql

[robocap]

Hello
we have whm in my server
in whm is one part to name
Repair Mysql Database


this is only for one database
how may i repaired all database in my server?

Thanks

[psrsathish]

Hi,

Its not possible to repair all the databases in one time. You need to repair each and every database separately.

[Nhojohl]

mysqlcheck -Aao --auto-repair -u root --password="ROOTPASS"

use the quotes also :P

[cimi_nl]

/etc/rc.d/init.d/mysql stop

2) Repair all SQL databases:
myisamchk -r /var/lib/mysql/*/*.MYI

3) Start mysql again:
/etc/rc.d/init.d/mysql start

Unit Parts Company europa dns
www.phpnuke.eu www.upcdns.com

[koolcards]

/etc/rc.d/init.d/mysql stop

2) Repair all SQL databases:
myisamchk -r /var/lib/mysql/*/*.MYI

3) Start mysql again:
/etc/rc.d/init.d/mysql start

Unit Parts Company europa dns
www.phpnuke.eu www.upcdns.com

The 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

[freedman]

Hi,

Its not possible to repair all the databases in one time. You need to repair each and every database separately.

mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize

[Fernis]

mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize

This worked great for me. Thanks for posting this!

[bipsa]

Software Repair My sql is aimed at issuing maximum assistance to Sql users by easily recovering table structure and data, key attributes related to tables like primary or referential key attributes. Views, procedures, triggers and functions are also recovered easily. Plat from which is supported by sql repair tool is the popularly used Windows OS and My Sql supported edition are 4.x and 5.x.