One of our database table tblpages seems to be corrupted. When I select the table, its says

show full fields from `favc`.`tblpages`
Table 'tblpages' doesn't exist

So I thought repairing it will be possible. I run a repair on the table and got this unsuccessful message.

tblpages                    repair  Warning   InnoDB: Tablespace is missing for table 'tblpages'
tblpages                    repair  Error     Table 'tblpages' doesn't exist                    
tblpages                    repair  status    Operation failed    

I don't have any latest copy of this table. Please help with any advise you may have. Thanks!

  • Are you using Innodb file per table? If so please check the filesystem for the favc/tblpages.ibd file. Are you making backups of your data? Can you restore it to another server, roll it forward using binary logs then dump the table out logically. – eroomydna Jan 15 '14 at 21:13
  • Okay, Let me try that. – Navneil Naicker Jan 15 '14 at 21:20

in my case I could simply fix the table-space-missing problem by:

cd /var/lib/mysql/psa/
cp -a ModuleSettings.ibd.bak ModuleSettings.ibd

psa.ModuleSettings was the table which gave me «#1812 table space is missing»-erros.

| improve this answer | |
  • 2
    this is not a solution..it is not working – Ankit Kapoor Oct 18 '17 at 12:29
  • Not every solution could work for every system. – Fusca Software Nov 7 '17 at 15:00

"Tablespace is missing for table XXXX”

There are broadly three ways in which this error can happen:

  1. Table files have the wrong ownership/permissions
  2. The table file is misplaced
  3. The data file is corrupted or deleted

in my situation was: 1 - wrong permission, after hard copy/

other solutions can be found here: https://bobcares.com/blog/mysql-tablespace-is-missing-for-table/

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.