- 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:
Option 1. Run
mysqlcheckcommand to check and fix the database table:
Linux-based operating systems:
- Connect to server over SSH.
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck <database name> <table name> --repair -u admin
Windows-based operating systems
- Connect to server over RDP.
- Open command-line console cmd.exe with Administrator account.
- Plesk for Windows has two MySQL instances for user's databases (port 3306) and for Plesk software database (port 8306). Depending on what is required to fix select the from 2 options:
MySQL server on port 3306:
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.
Plesk SQL Server on port 8306:
C:\>"%plesk_dir%MySQL\bin\mysqlcheck" -P8306 -uadmin -p"plesk_admin_password" -r <database name> <table name>
Using web interface with SQL WebAdmin:
Select table and choose Repair table action.