4

MySQL Backup Without Overwriting New Rows

view full story
linux-howto

http://serverfault.com – Let's say I backup a database like this: mysqldump -u usrname -p pass dbname > dbbackup.sql Then I delete a pile of rows from dbname. Then new rows are inserted into dbname. However, I decide I want to 'undelete' the rows I deleted. How can I restore the dbbackup without overwriting the new rows? (HowTos)