Trouble Importing Backup

  • Unknown's avatar

    I am moving an old WordPress.org blog to my new WordPress.com site. My backup is from a previous version of WordPress, ending in sql.gz

    When I go to import the backup, it’s only offering me the option to restore from backup files ending in WXR.

    What do I need to do to import my blog?

    The blog I need help with is: (visible only to logged in users)

  • Unknown's avatar

    I’m sorry to hear you’re running into trouble with your import. In order to import your WordPress site into WordPress.com, you will need to use a .xml file. You can generate that by going to your existing site, and creating an export under Tools > Export.

  • Unknown's avatar

    This is an old blog, and is no longer existing, so the only thing I have is the sql.gz file. How can I convert it to the right file type so that I can use my site?

  • Unknown's avatar
    thistimethisspace · Member ·

    You need an XML file to be able to import into a WordPress.com blog. I typed “convert sql.gz file to an XML file” into Google and got these WordPress.ORG results.

    the solution is to import the sql.gz into the database
    http://codex.wordpress.org/Restoring_Your_Database_From_Backup

  • Unknown's avatar

    Since I am importing it into a WordPress.COM site, I can’t access a phpAdmin or anything like that, it’s just the WordPress.COM site.

  • Unknown's avatar
    thistimethisspace · Member ·

    I understand that. As you no longer have a self hosted site and as there is no blogger database access to free hosted WordPress.com blogs you need help from Staff and jackiedana will provide it when she can. I wanted you to comprehend why you cannot import that sql.gz file file directly into a WordPress.com blog.

  • Unknown's avatar

    Thanks thistimethisspace – how do I contact the staff?

  • Unknown's avatar
    thistimethisspace · Member ·

    jackiedana will return to this thread when she logs in. There’s nothing that can be done to expedite that. It’s the weekend so please be patient while waiting.

  • Unknown's avatar

    @debbiehardegree, we don’t have a way to do an automatic import from a sql.gz file. Your best bet is to try to create your own .xml/wxr file for import. If not, we can attempt an import from your file, but your media will not be imported and there could be other issues with the file.

    If your site was designed by a third-party, you might check with them, and you might check with your hosting provider to see if there are still any files there.

  • Unknown's avatar

    Unfortunately my old host has been completely unresponsive, and the site was just the default theme that came with WordPress. There really weren’t many photos, it was almost completely all text – is that something y’all can work with? I don’t know how to create a xml/wxr file. (Sorry, very much not technically inclined!)

  • Unknown's avatar

    As a developer warned me, this kind of import doesn’t work particularly well, but we are happy to give it a try.

    If you can either upload the file to a file sharing service like Dropbox and then let me know, or send me a link via email (include my name in the subject line and a link to this thread in the message so I can find it), we can go from there.

    Would you want this imported to your debbiehardegree.wordpress.com blog or a different one?

  • Unknown's avatar

    Let’s give it a try (and thank you so much for helping)!

    I’ll email you a link to a Dropbox file momentarily. I’ve redirected http://www.debbiehardegree.com so that it’s the primary URL for debbiehardegree.wordpress.com, so that’s where I was thinking it would go (it’s the only blog set up in my account). Thank you!!!

  • Unknown's avatar

    Thanks for the file. I’ll let you know how it goes.

  • Unknown's avatar

    I have been able to import your file into your WordPress.com blog. I hope everything is there. Please let me know how it looks.

  • Unknown's avatar

    THANK YOU!!! It looks like everything transferred, we were so worried we had lost this. I really appreciate your help with this!

  • Unknown's avatar

    That’s awesome! I wasn’t sure how much we were able to capture. It’s great that it worked!

  • The topic ‘Trouble Importing Backup’ is closed to new replies.