LinuxCommandLibrary

mysqlcheck

Check and repair MySQL tables.

TLDR

Check a table

$ mysqlcheck --check [table]
copy


Check a table and provide credentials to access it
$ mysqlcheck --check [table] --user [username] --password [password]
copy


Repair a table
$ mysqlcheck --repair [table]
copy


Optimize a table
$ mysqlcheck --optimize [table]
copy

Copied to clipboard