How to repair website MySQL/MariaDB databases and tables in Plesk?

Dmitry Bystrov

4 months ago

Question

How to repair non-InnoDB MySQL/MariaDB tables on Plesk server?
How to repair website MySQL/MariaDB databases and tables in Plesk?
How to repair domain MySQL/MariaDB databases and tables in Plesk?

Answer

Log into Plesk
Go to Domains > example.com > Databases and click Check and Repair for the required database

Command-line solution

Linux-based operating systems:

Connect to server over SSH
Execute the below command substituting required table and database:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck <database name> <table name> --repair -u admin

Windows-based operating systems

Connect to server via RDP
Open command-line console cmd.exe with Administrator privileges.
Execute below command substituting required table and database:

C:>"%plesk_dir%MySQLbinmysqlcheck" -P3306 -uadmin -p -r <database name> <table name>

If the password is unknown, reset it according to this KB article.

Not all the storage engines in MySQL//MariaDB database support repair of the tables. If storage engine does not support repair the following message will appear:

The storage engine for the table doesn't support repair

In such a case, follow the instructions provided in the article: How to fix InnoDB corruption cases for the MySQL database?

Additional Information

How to access MySQL databases?

0 Shares