MySQL repair tables

If you’re ever stuck with broken tables in MySQL or MariaDB and you don’t know which, you can use the mysqlcheck command to repair them all, one by one (you can also use the –optimize argument).

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

It's only fair to share...Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Share on Tumblr
Tumblr
Email this to someone
email
Posted in:

Leave a Reply

Your email address will not be published. Required fields are marked *