underblob

Popsicles don’t stay frozen in a cooler full of ice.

Hatred does not cease through hatred at any time.
Hatred ceases through love. This is an unalterable law.
– Buddha

I had a couple records disappear and needed to pull them from backup. The client had already made extensive changes to the database via CMS so I couldn’t copy over the whole database without overwriting all of their changes. Here is the SQL I came up with to transfer a single record:

INSERT INTO target_db.table
SELECT backup_db.table.* 
FROM backup_db.table
WHERE backup_db.table.id = '{000}'

Replace target_db with the name of the database you are copying to.
Replace backup_db with the name of the backup database you are copying from.
Replace table with the name of the table you are handling.
Replace {000} with the id field value of the record to transfer.