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}}
License and Disclaimer
The content on this page is copyright © 2014—present the tldr-pages team and contributors.This page is used with permission under Creative Commons Attribution 4.0 International License.
While we do attempt to make sure content is accurate, there isn't a warranty of any kind.