How Do I Repair All MySQL Data Bases via SSH running Linux with cPanel

Prev Next

This is an advanced task requiring SSH access and command line familiarity

Incorrectly running commands without knowing what they do or how they function could affect your server, even leaving in an unusable state requiring a reinstall. Only run commands if you have experience, or reach out to our Support Team if you need help.

For all Databases

  1. Log in via SSH as root

  2. Run the following Command:

mysqlcheck --all-databases -r

For a single database

mysqlcheck -r database_name