Support » Fixing WordPress » Retrieving Posts From Crashed WP Site

  • Hi forum, Some time ago my WP site crashed. I was able to save the database from that site on my computer hard drive. What I need to do is to retrieve my posts and pages from that WP database. Could someone tell me the steps to do this task? I do have the database on my hard drive. What do I need to do to get my content from that WP DB? Can you help?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Did you copy the mySQL data files or did you export the tables?
    Depending on the query engine used, moving the files can make them unusable since the index is messed up. But exported tables can be imported easily.
    You can install WordPress on your computer to handle that,

    Installing WordPress on your own Computer


    or try a sandbox like http://poopy.life/
    Use a plugin like https://wordpress.org/plugins/wp-phpmyadmin-extension/ to access the database directly to import the posts table, which is where the content is. (it also has attachments and menu items and revisions) If you need the tags and categories, you’ll need to do those tables also. Don’t do the options table since it will mess up your installation. The user table might conflict with whatever new installation you are using, but if you need it for authors, you could carefully add those manually.

    Try creating a new WordPress installation and if possible, add and activate the theme you had when the site crashed. If you had a page builder activated, add it too. Next, use PHPMyAdmin and import the data of the old database to the current (new) one. You may get a message like “WordPress Needs To Configure The Database”, let it finish and visit the website. If you’re lucky, the posts and pages should be there.

    If it doesn’t work, try with previous versions of WordPress and the theme. If you can estimate the time when the incident happened, you can even find the exact version. Check here https://wordpress.org/download/releases/

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Retrieving Posts From Crashed WP Site’ is closed to new replies.