WordPress.org

Forums

Recover page content for specific pages (9 posts)

  1. J Howard
    Member
    Posted 2 years ago #

    Hello. I've taken a look through past forum posts regarding this, but couldn't find anything relating to this specific requirement. Does anyone know how to recover data for a particular page within WordPress? All I can find in past forum posts, are instructions for recovering an entire WordPress site, or all posts. I have regular backups, reverting back to the date whereby the page content may have been accidentally deleted. The original page still exists, it's just that the content doesn't! I'd be incredibly grateful for any feedback received. Many thanks.

  2. JungleSpace.net
    Member
    Posted 2 years ago #

    If you have the sql backup file or the export file, you can open the file in the text editor and look for your post content. Copy out the relevant content and paste it through your WordPress panel.

  3. J Howard
    Member
    Posted 2 years ago #

    Thanks for the reply JungleSpace. In what section of the WordPress database do I need to be looking in for this, and can I use a search utility to track down the specific entry/page id? Thank you.

  4. JungleSpace.net
    Member
    Posted 2 years ago #

    Yeah you can search using page id, page title or if you remembered any specific paragraph in your content.

  5. racer x
    Member
    Posted 2 years ago #

    Have you checked your revisions? Unless you have a plugin or are manually limiting the number of revisions, there is a good chance you can simply refer to an older version before the content was deleted.

    You can search your SQL backup as suggested, but keep in mind that file will have some SQL specific formatting. (Like '' for single quotes, etc.)

  6. J Howard
    Member
    Posted 2 years ago #

    Thanks for the replies, everyone. What I suddenly thought about last night, was, how do I restore a previous SQL backup into phpMyAdmin, in order to search through for my content, without it being 'live' or potentially causing conflicts / issues with the actual current 'live' database?

  7. J Howard
    Member
    Posted 2 years ago #

    @racer x - After looking through my wp-config.php file, the WordPress site creator has added in 'define(‘WP_POST_REVISIONS’, false);'. Poop.

  8. J Howard
    Member
    Posted 2 years ago #

    Can I ask if anyone has any thoughts regarding my last post? (displayed again below). Apologies for badgering, but I'd really like to get this sorted!
    '..Thanks for the replies, everyone. What I suddenly thought about last night, was, how do I restore a previous SQL backup into phpMyAdmin, in order to search through for my content, without it being 'live' or potentially causing conflicts / issues with the actual current 'live' database?..'

  9. JungleSpace.net
    Member
    Posted 2 years ago #

    You can import the sql into a new database(new name). It wont affect the live site as long WordPress is not set to connect to the new database.

    You can also setup WordPress on your own computer using the backup sql data.


    http://codex.wordpress.org/Restoring_Your_Database_From_Backup

Topic Closed

This topic has been closed to new replies.

About this Topic