- Plesk for Windows
- Plesk for Linux
How to repair non-InnoDB MySQL tables on Plesk server?
Note: 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:
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?
If the storage engine supports repair operation, there are the following options:
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.