The free forums are no longer in use. It remains available as read-only archive.
Log In
Home
The forums are currently locked and only available for read only access
Restore Backup - Database tables already exists error
July 2, 2011
4:55 am
4:55 am
Andreas
Member
Members
Forum Posts: 4
Member Since:
July 1, 2011
July 1, 2011
Offline
When I restore a backup to the remote server via Xcloner and only want to update/overwrite the database I get the "Database table xyz already exist" error.
When creating a Backup in the local site I checked the "Add Drop Syntax" option but it always throws an error when restoring on the remote server when the databse is not empty. Is there a workaround other than dropping all tables before doing a database restore?
Any help is greatly appreciated...
July 2, 2011
9:27 am
9:27 am
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
September 26, 2010
Offline
Most probably the restore mysql user is not allowed to execute the drop tables syntax, try and check it's assigned permissions, otherwise the only possibility is to use an empty database when restoring!
Ovidiu
All RSSForum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
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:
Omar VeraModerators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0
© Simple:Press —