- Plesk for Windows
- Plesk for Linux
How to repair non-InnoDB MySQL tables on Plesk server?
Go to Domains > example.com > Databases and click Check and Repair for the required database.
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 comand substituting required table and database:
MYSQL_WIN: C:>"%plesk_dir%MySQL\bin\mysqlcheck" -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 database support repair of the tables. If storage engine does not support repair the following message will appear:
CONFIG_TEXT: 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?