I have a few servers that have clone copies of production sites. The big challenge is to migrate back, production data into the dev server without dropping the database.
Quite often, I just clear the database so that I can import transparently.
A cool command that I use is:
1 mysqldump -u $USER -p$PASS --add-drop-table --no-data $DB | grep DROP | mysql -u $USER -p$PASS $DB
Now I can absorb it
1 cat /tmp/dbdump | mysql -u $USER -p$PASS $DB