Optimizing and repairing MySQL databases with mysqlcheck

In this post, we will talk about mysqlcheck which is a maintenance command line tool that allows you to check, analyze, repair, and optimize MySQL/MariaDB tables and databases.

Check one table in the database

The following command will check the table posts in the database blog:

$ mysqlcheck -c blog posts blog.posts OK

If your database is protected by a password add -u root -p at the end of the command:

$ mysqlcheck -c blog posts -u root -p Enter password: blog.posts OK

Full Story