Recover deleted post with database backup

  • duff1

    (@duff1)


    9 years, 10 months ago

    Hi!

    I installed a plugin and I did a wrong operation that deleted some of my posts. I can recover it because I have a backup but some recent changes need to be kept.

    So I want to get back only my lost posts. How can I do that? Which database tables concern posts?

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Denzel Chia

    (@denzel_chia)

    9 years, 10 months ago

    Hi,

    Depending on what’s in your post, whether there is custom field or category or tags… it links up to a few tables.

    Therefore, it’s not a good way to look directly into database backup.
    You should create a localhost WordPress installation and import your database backup. Then look for the post via WordPress admin.

    Thank you.

    Thread Starter duff1

    (@duff1)

    9 years, 10 months ago

    And when my database is restored on the temporary site, how can I transfer the missing posts?

    I can’t just restore the database without overwritting existing data? I can’t see that kind of option in phpmyadmin’s import and could be easier.

    Thread Starter duff1

    (@duff1)

    9 years, 10 months ago

    I followed your recommendation to import the database in a fresh new WordPress.

    Next, I exported all the posts with Tools -> Export and saved the XML file.

    After that, I removed the posts already in my site and simply imported the file. I removed some posts by ignoring if WP would overwrite them or create duplicate. Can you answer me on this?

    Thanks for your advice!

    Denzel Chia

    (@denzel_chia)

    9 years, 10 months ago

    Hi,

    And when my database is restored on the temporary site, how can I transfer the missing posts?

    Find them in your WordPress admin.
    Manually copy the content and create on your live site….

    I can’t just restore the database without overwritting existing data? I can’t see that kind of option in phpmyadmin’s import and could be easier.

    Nope, don’t think it’s possible.

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Recover deleted post with database backup’ is closed to new replies.