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.

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