Restore Without DB- From Google Cache- Can it be done?

  • Though I could not find mention of it here, I am confident that someone has had this same issue before. The server that our site lived on took a crap recently and we lost almost everything. All of our WP files and media and pictures had been backed up, but not the actual DB. We’ve got the site back up and running more or less, but are hoping to recover the old posts- almost all of which can be found in the google cache (but for how long I don’t know)- and reenter them somehow. Has anyone done this or know that it has been done?

    Here’s my main question I guess: once we recover that text, we would want to archive it more or less according to its original date of posting (just over two years total). Is there a way to retroactively build these posts back into the DB to show up as having been from the original date of posting? Is there any easy way to do this in bulk or en masse?

    Any thoughts, suggestions, or advice would be truly appreciated.

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

  • theres absolutely NO way to do that easily.

    You are either going to be copying and pasting into file that you batch import into the database, and then you’re going to be missing data (thats also a huge pita to explain to someone thats never done it), or you are going to be copying & pasting into the MySQL tables directory (again still missing data), or you are going to be re-posting everything into WordPress, just like they were new posts – only that way, you get to make sure you enter all the necessary fields that MySQL needs.

    My advice, do it the third way, and get in the habit grabbing backups of your database.

    Thread Starter bigrome

    (@bigrome)

    Thanks for the advice. If any one else has done this and has other recommendations, I am all ears.

    As whooami said, copying and pasting, is probably your best bet. I would elect to copy and paste each one as a new post (Write->Write Post). You can use the timestamp to set the date to the original post date if necessary.

    Also filosofo has the WordPress Backup Plugin and it can email the darn backup…
    https://www.ilfilosofo.com/blog/wp-db-backup

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Restore Without DB- From Google Cache- Can it be done?’ is closed to new replies.