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