HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

InnoDB: Tablespace is missing for table

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
tablespaceinnodbformissingtable

Problem

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!

Solution

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.

Warning: It's possible you lose some newer data.

Code Snippets

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

Context

StackExchange Database Administrators Q#56849, answer score: 3

Revisions (0)

No revisions yet.