At work today somebody accidentally deleted a couple rows from our production database. Normally, this wouldn't be so bad but when the website deleted those row it also deleted a little over a 150 other rows that were dependent on it. I would just copy these rows over using an insert ... select but those can be error prone when dealing with the 25 columns that this table had so I had to find another way to restore the data.

mysqldump has a parameter that allows you create a dump file that allows you to specify what rows to dump:

mysqldump -uroot -ppassword databaseName tableName --where='foreignId in (802, 803, 804)'