Wordpress Restore Table Already Exists | Wordpress Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_Feed Topic RSSsp_TopicIcon
Wordpress Restore Table Already Exists
March 25, 2011
12:34 pm
Avatar
Clark
New Member
Members
Forum Posts: 2
Member Since:
March 25, 2011
sp_UserOfflineSmall Offline

Hi,

 

I've created a backup fine on one sever and I'm trying to restore it on another server. I've selected the "Add Drop Syntax" as the table already exists on the new server. This is verified by the file name containing "drop" in the name and doubly verified by having a look at the sql and seeing the IF TABLE EXISTS DROP lines. When I'm going through the sql restore I constantly get table already exists.  I've check the user permissions and they are ok. Anyone got any ideas?

 

Thanks

March 25, 2011
1:56 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Hi Clark! Could you open the administrator/backups/database-sql.sql file from inside the database, does it contain the drop table syntax for each table?

 

Ovidiu

March 25, 2011
2:03 pm
Avatar
Clark
New Member
Members
Forum Posts: 2
Member Since:
March 25, 2011
sp_UserOfflineSmall Offline

Hi,

Yes every table has the DROP table IF EXISTS before it.

Thanks

March 25, 2011
2:14 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Ok, then i would advise checking that the mysql user you used for import has rights to drop the existing tables, if not, better use an empty database when doing the restore.

 

Ovidiu

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
Andy: 21
D: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10030
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Emmanuel Joachim
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0