Tablespace is missing for a table
We've started receiving "Tablespace is missing for a table" mysql errors for our wpforo_profiles table. Running check table in phpmyadmin gives:
- Warning Tablespace is missing for table 'db_name/prefix_wpforo_profiles'
- Error Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
- Error Corrupt
If we can't fix this issue and need to restore from backup, do we need to be careful about synchronization issues between this table and any other tables containing user data? Thanks.
Basically what I'm asking is, if we need to replace the wpforo_profiles table from backup, do we also need to replace other wpforo tables - and maybe even other Wordpress tables - at the same time, to ensure consistency between our data?
Press Synch User Profiles button from wpForo > Overview, after replacing the table with the backup.
Thanks Chris. Is it possible to just replace wpforo_profiles with an empty table and then synch the user profiles? Would that work? Otherwise we're going to need to replace the entire db from backup and lose some other changes/content.
I've just tried this and I think the answer is no, this won't work. It's possible to create an empty table and synch the profiles successfully but there's a lot of data which would previously have been in the wpforo_profiles table which is missing.