Unanswered: How to Update duplicate rows upon restoring of DB....
We update our database on our local server and upload a mysqldump everynight to update the Live database.
Upon running the following commant, I get a "duplicate entry" error:
mysql -u root -p LiveDB < "/home/LocalDump.sql"
What I'd like is the restore to REPLACE duplicate entries (not report an error). I would like it to take the row from my local database backup and replace the rows on the live database. How can I do this?