Mysql Error-could not open single-table tablespace file
Unable to start MySQL/mysqld service. The following errors are foundin /var/log/mysqld.log:
[ERROR] InnoDB: innodb-page-size mismatch in tablespace ./phpmyadmin_rq_U9tqAuU26/pma_central_columns.ibd (table phpmyadmin_rq_U9tqAuU26/pma_central_columns)... InnoDB: Error: could not open single-table tablespace file ./phpmyadmin_rq_U9tqAuU26/pma_central_columns.ibd
Crash recovery of InnoDB cannot be finished because the table is corrupted during the recovery process.
- Log in to the server via SSH.
Move the file mentioned in the error message to the other directory:
$ mv /var/lib/mysql/phpmyadmin_rq_U9tqAuU26/pma_central_columns.ibd ~/
Start the mysqld service (InnoDB recovery process will be executed automatically):
$ service mysqld start