Page 1 of 1

Restore MySQL table

Posted: Sun Nov 02, 2014 3:31 pm
by TonsOfFun
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?

Re: Restore MySQL table

Posted: Sun Nov 02, 2014 4:24 pm
by Celauran
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

Posted: Sun Nov 02, 2014 4:28 pm
by TonsOfFun
No backups. Where would I find those files? The site is on shared hosting.

Re: Restore MySQL table

Posted: Sun Nov 02, 2014 4:59 pm
by Celauran
Probably /var/lib/mysql, though cPanel could have changed that to use its own path.