How to restore deleted records in MySQL

This assumes you have a disk backup!

• Create a new server mounting the old disk
• mysqldump -u <user> -p <database> <table> --where="<condition>" --no-create-info > records_to_restore.sql
• Check the sql contains the inserts you want
  • in particular, that it does NOT contain DROP/CREATE tables statements. That’s what “no-create-info” is for.
• Copy the file to the original server
• mysql -u <user> -p <database> < records_to_restore.sql