Importing an old backup file into my new WordPress site

  • Resolved wellnesscarousel

    (@wellnesscarousel)


    8 years, 1 month ago

    I had an old WordPress site that I shut down in 2015, but before I shut it down, I downloaded a backup file.

    I just started a new site, and I want to re-use some of my old articles and info from the previous site, but I cannot figure out how to get the old posts into my new site.

    The new site has a completely different look and theme, so I don’t want to import the entire old site. I am fine with just finding the text and images and copying those into my new site to create totally new posts.

    I tried using the importer in WordPress under Tools – Importer, but it wouldn’t work because I don’t have a WXR xml file. I found a file that is a .sql file that is 12.7mb and I opened it with TextEdit so I can tell that’s my content, but I can’t figure out what to do with it to get it into my new site.

    The backup file is a zip file, and when I unzipped it, I have loads of folders that don’t mean much to me because I am not super technical. I can follow directions though, so I would appreciate any help anyone can offer to help me recover this old data.

    Many thanks in advance.

    The page I need help with: [log in to see the link]

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

    (@paulwp)

    8 years, 1 month ago

    I just started a new site, and I want to re-use some of my old articles and info from the previous site

    So we just need some articles from old site so we don’t really need to make a complete thing setup. I suggest just install a new (separated from your new site) WP using local machine, or do it on a subdomain of your live site would work too. And then just get your articles in a copy/paste fashion.

    The WP importer (xml) works only for text, as for the image it needs the original site to be online. So in this case it’s better to just import the sql file using phpmyadmin.

    Restore Process
    https://codex.wordpress.org/Restoring_Your_Database_From_Backup

    Depending on the amount of content that you need from old site. If it’s not that much, just opening up the sql file with text editor (just like you did) and get the text from article manually, and look for the images that belongs to each article inside the wp-content/upload/ folder.

    Thread Starter wellnesscarousel

    (@wellnesscarousel)

    8 years, 1 month ago

    Thank you very much for the reply. I think I can actually get the text manually for most of the articles. That seems to be the fastest and least complicated way to do it (for a non-tech expert like myself)

    Many thanks!

    Thread Starter wellnesscarousel

    (@wellnesscarousel)

    8 years, 1 month ago

    .

    paulwpxp

    (@paulwp)

    8 years, 1 month ago

    @wellnesscarousel Yes, I would do the same if the amount of content is not that much.

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

The topic ‘Importing an old backup file into my new WordPress site’ is closed to new replies.

Tags