Lyndon Li's Blog

Mysql Error-could not open single-table tablespace file

Lyndon mysqllinux

Symptoms

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

Cause

Crash recovery of InnoDB cannot be finished because the table is corrupted during the recovery process.

Resolution

  • 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
    
Lyndon
一个保持清醒的沉睡者