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
Subject
Views
Written By
Posted
2409
May 13, 2014 09:31AM
Re: Restoring a backup that has UNIQUE index violations in it
1294
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.