Import db without violating unique constraints
I create a dbdump using a cron job that runs everyday :
mysqldump -u user -ppass --opt --complete-insert --triggers --single-transaction <dbname>> dbv1_%date:~7,2%-
I now want create another cron job on another db that keeps the backup (I have to make this other db the master for the third db, thus cannot use automatic replication here). But since there are unique contraints on most of the tables, the import fails saying that the constraints are getting violated.
How should I import the db in append only mode ?
Subject
Views
Written By
Posted
Import db without violating unique constraints
1851
December 25, 2015 12:51PM
1103
December 26, 2015 02:14PM
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.