MySQL Forums
Forum List  »  Backup

Import db without violating unique constraints
Posted by: Pooja Gupta
Date: December 25, 2015 12:51PM

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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Import db without violating unique constraints
1771
December 25, 2015 12:51PM


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.