XF 2.3 Innodb Tablespace Missing

[nathanw]

Hi all,

Unexpectedly, earlier today something corrupted four tables in the XF database:
xf_attachment_view
xf_mg_album_view
xf_mg_media_view
xf_thread_view

"show table status;" on the xenforo database shows the comment "Got error 194 "Tablespace is missing for a table" ..." for those tables.

When I look at the .ibd files for those tables, they've been zeroed out with repeating "@^".

Annlyingly, I do not have a backup of the XF database due to a separate issue, so there are no rollback options availabel for me.

If I dump the xenforo database without those tables and then restore, what data will I have actually lost?

Any other advice other than "take regular backups and store them offsite!!!!!!"?

 

[Jeremy P]

These tables store ephemeral data which is regularly swept and truncated. You can drop and recreate them without losing much important.