Check and Repair Database with WP-CLI

When a WordPress website shows an Error establishing a database connection, those with access to cPanel can check and repair databases using MySQL Database or phpMyAdmin. Below, we cover how web developers can check and repair a WordPress database using WP-CLI.

Note: You must navigate to the root folder of your WordPress installation in SSH or cPanel Terminal to continue.

Check Database

Type the wp db check WP-CLI command. You’ll see results listing each table, then OK or
note : The storage engine for the table doesn’t support repair.

cpuser01_bgri000.wpa0_terms OK
cpuser01_bgri000.wpa0_usermeta OK
cpuser01_bgri000.wpa0_users OK
Success: Database checked.

Repair Database

Type the wp db repair WP-CLI command. You’ll see results listing each table, then OK or
note : The storage engine for the table doesn’t support repair.

cpuser01_bgri000.wpa0_terms OK
cpuser01_bgri000.wpa0_usermeta OK
cpuser01_bgri000.wpa0_users OK
Success: Database repaired.


If this doesn’t fix your issue, even after clearing your browser and server cache, please contact our Live Support for further assistance.

Leave a Reply