Plesk SQL server upgrade fail:
Table './mysql.<TABLENAME>' was created with a different version of MySQL and cannot be read
Most probably error is a result of previous unresolved MySQL engine errors.
Check database with
mysqlcheck and move reported tables out from the database directory.
For example, we have an error:
Table './mysql/ndb_binlog_index' was created with a different version of MySQL and cannot be read
- Navigate to MySQL data directory, usually it located in '
- Select all files with name
- Move them somewhere from this folder.
- Recheck again
- Re-run Plesk upgrade
For additional information regarding MySQL database troubleshooting please refer this KB article