The table in question seems to have been deleted. When I try to re-create the table I get this error:
[text]#1813 - Tablespace for table '`database`.`table`' exists. Please DISCARD the tablespace before IMPORT. [/text]
Is it possible to restore the old table with the data?
If not, how do I discard the tablespace so I can re-create the table?
Restore MySQL table
Moderator: General Moderators
Re: Restore MySQL table
There are a lot of 'depends' in there. Do you have backups? Is the .idb file present and .frm file missing, or vice versa?
Re: Restore MySQL table
No backups. Where would I find those files? The site is on shared hosting.
Re: Restore MySQL table
Probably /var/lib/mysql, though cPanel could have changed that to use its own path.