MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases

Note: This article will be emailed to your friend.

Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:

mysqlcheck -u root -p –auto-repair –check –optimize –all-databases
mysqlcheck is available in MySQL 3.23.38 and later.
mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the [...]

Read the rest of this article (149 words)

Please fill in the following fields

* - Required

Your Name: *

Your E-Mail: *

Your Remarks:

Friend's Name: *

Friend's E-Mail: *

Protected by Comment Guard Pro