MySQL Check All Tables in Database

If you need to check (not repair) all your tables at once , run the following command in your shell;

mysqlcheck -h hostname -u username -p -A -c 

You will be prompted to enter the password.


-A means check all databases 

-c means 


Click here to view how to repair all tables.

Rate this blog entry:
Git Ignore All Except Some Files
JQuery Validate Multiple Dynamic Inputs

Comments

 
No comments yet

Latest Comments

Susan Hermiston Virtual Hosts
October 7, 2015
Wow 747 just blew me away. Sorry not a tech person at all!! But I still love you!! Rock on!!?
Johmny Invisible Mouse Cursor Ubuntu & Synergy
September 2, 2015
Glad I was ble to help!
Kristian Falk Invisible Mouse Cursor Ubuntu & Synergy
September 1, 2015
Thank you for this! Had the exact same problem. I almost went crazy.