PHP Developers Network

A community of PHP developers offering assistance, advice, discussion, and friendship.
 
Loading
It is currently Tue Dec 18, 2018 5:23 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Restore MySQL table
PostPosted: Sun Nov 02, 2014 4:31 pm 
Offline
Forum Commoner

Joined: Wed Jun 02, 2010 7:37 pm
Posts: 54
The table in question seems to have been deleted. When I try to re-create the table I get this error:
Syntax: [ Download ] [ Hide ]
#1813 - Tablespace for table '`database`.`table`' exists. Please DISCARD the tablespace before IMPORT.

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?


Top
 Profile  
 
 Post subject: Re: Restore MySQL table
PostPosted: Sun Nov 02, 2014 5:24 pm 
Offline
Moderator
User avatar

Joined: Tue Nov 09, 2010 3:39 pm
Posts: 6424
Location: Montreal, Canada
There are a lot of 'depends' in there. Do you have backups? Is the .idb file present and .frm file missing, or vice versa?

_________________
Supported PHP versions No longer supported versions


Top
 Profile  
 
 Post subject: Re: Restore MySQL table
PostPosted: Sun Nov 02, 2014 5:28 pm 
Offline
Forum Commoner

Joined: Wed Jun 02, 2010 7:37 pm
Posts: 54
No backups. Where would I find those files? The site is on shared hosting.


Top
 Profile  
 
 Post subject: Re: Restore MySQL table
PostPosted: Sun Nov 02, 2014 5:59 pm 
Offline
Moderator
User avatar

Joined: Tue Nov 09, 2010 3:39 pm
Posts: 6424
Location: Montreal, Canada
Probably /var/lib/mysql, though cPanel could have changed that to use its own path.

_________________
Supported PHP versions No longer supported versions


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group