Repair all MySQL databases

2009-03-23 10:43:00 by Saz

If you need to check and repair all MySQL databases you can use:

mysqlcheck -u USER -p -Ar

If you also want to optimize them, use:

mysqlcheck -u USER -p -Aor
-A: all databases
-o: optimize
-r: repair

Have a look at the man page of mysqlcheck for more information.


Fork me on GitHub