By kenahoo on

Mysteriously, a node on the site seems to have reverted to an old copy, or had part of it deleted, or something. It looks like everything above the "split summary at cursor" point is now gone. I wonder if some of the non-ASCII characters I was using caused some problems.

In any event, I have daily backups of the entire mysql DB, and I'd like to find yesterday's code for that node and restore it.

What table is best to look in?

⋅ Categories: Drupal 6.x

Comments

zbricoleur’s picture

zbricoleur commented

If it doesn't have CCK fields, the whole node should be in {node_revisions}

fuzzy76’s picture

fuzzy76 commented

I'd restore the backup to a database locally and just copy-paste the body contents into the production database.