Repairing and Checking MySQL and MariaDB Database Tables

You can use the commands below to learn how to check and repair errors in your MySQL or MariaDB databases and/or tables.

You can use the command below to check.

mysqlcheck -o --all-databases

You can use the following command for Checking and Repair.

mysqlcheck --auto-repair -o --all-databases

The parameters are below.

-c = Control
-a = Analysis
-o = Optimize
-r = Repair
-A = All Databases
--auto-repair = Auto Repair
--tables = Tables