Question
- How to repair domain MySQL/MariaDB databases and tables in Plesk?
Answer
-
Go to Domains > example.com > Databases and click Check and Repair for the required database
Command-line solution
Linux-based operating systems:
-
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
-
Open command-line console
cmd.exewith 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?