MySQL Forums
Forum List  »  Data Recovery

Re: Restoring a backup that has UNIQUE index violations in it
Posted by: Tim Nope
Date: May 18, 2014 10:04AM

Hello list,


it turned out that the problem was not at all caused by duplicate data in the database:

When I created the backup using PhpMyAdmin 4.0.4.2, I also exported the views. When I had a look at the backup in a text editor, the backup contained the table data twice -- in the tables AND in the views.

Updating to PhpMyAdmin 4.2.1 AND manually removing the views from the export created a backup that could be restored without the error described above.

Problem solved.

Greetings,

Tim

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restoring a backup that has UNIQUE index violations in it
1230
May 18, 2014 10:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.