Thursday, August 01, 2013

mysql db table repair for phplist

As a follow-up to this earlier post on table repair, PB suggested the following:
He found that the following one line command checks, repairs and optimizes all the databases.

 mysqlcheck -u root -p --auto-repair -c -o --all-databases

This could be used  in situations where we are not sure of which tables have crashed or needs repair.....

No comments:

Post a Comment