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?

I am running MySQL 3.23. Please help.

Thanks in advance.

Warm Regards,