# How to restore an old revision of a Ghost blog post using SQL

**URL:** <https://forum.ghost.org/t/how-to-restore-an-old-revision-of-a-ghost-blog-post-using-sql/31221>\
**Category:** Developer help\
**Created:** [July 8, 2022, 4:42pm UTC](https://forum.ghost.org/t/how-to-restore-an-old-revision-of-a-ghost-blog-post-using-sql/31221 "2022-07-08T16:42:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![markstos](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/markstos/32/18182_2.png) [@markstos](https://forum.ghost.org/u/markstos)\
**Post date:** [July 8, 2022, 4:42pm UTC](https://forum.ghost.org/t/how-to-restore-an-old-revision-of-a-ghost-blog-post-using-sql/31221/1 "2022-07-08T16:42:24Z")

</div>

Ghost saves the last 10 revisions of blog posts but doesn’t provide a user interface to restore it.

I pushed a How To for how to restore old post revisions using SQL. This completely restores all the blocks and formatting. You’ll need access to your SQL database behind the Ghost site to follow the tutorial:

> **[Reverting to previous post revision in Ghost using SQL](https://mark.stosberg.com/reverting-to-previous-post-revision-in-ghost-using-the-cli/)**
>
> Ghost 5.2 stores the last 10 revisions of blog posts in the database, but currently there's no interface to revert to a prior version using the web interface. Here's how you can restore a previous revision if it's not too later.
> 
> 
> 
> What to do if you...