Sodamhan.com

TL;DR

mysqlcheck

Check and repair MySQL tables. More information: https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html.

  • Check a table:

mysqlcheck --check table

  • Check a table and provide credentials to access it:

mysqlcheck --check table --user username --password password

  • Repair a table:

mysqlcheck --repair table

  • Optimize a table:

mysqlcheck --optimize table

This document was created using the contents of the tldr project.