Ghost post restoration script (MySQL version)

restore_script.sql

-- show available versions for a post
SELECT `mr`.`id` 'version id', `p`.`id` 'post id', `p`.`title`, `mr`.`mobiledoc` 
FROM `posts` `p` 
JOIN `mobiledoc_revisions` `mr` 
ON `p`.`id` = `mr`.`post_id` 
WHERE `p`.`id` = '$POST_ID' \G

-- restore specific versions of the post
UPDATE `posts` `p`
JOIN `mobiledoc_revisions` `mr`
ON `p`.`id` = `mr`.`post_id`
SET `p`.`mobiledoc` = `mr`.`mobiledoc`
WHERE `mr`.`id` = '$VERSION_ID';