SQL Backup File From Self-Hosted Website to XML File

  • Unknown's avatar
    audreyrm1982 · Member ·

    I had a self-hosted website and did not renew hosting. I am only left with the SQL file that is my backup sent to my e-mail. When I import to WordPress.com, it needs an XML file. How do I change an SQL to XML? Anybody know how?

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

  • senff · Staff ·

    I would suggest to set up a new self-hosted site temporarily first, and import the SQL file you have on that.

    Then, when that site is up and running, you can make a new export in XML format, that you can then import in your new WordPress.com file.

    A few notes:
    – an SQL file contains pretty much all information about your site. Not just posts/pages and their contents, but also all configuration settings.
    – an XML file contains just the content you created for a site. Posts, pages, and some additional info (image library, etc.)
    – to set up a new self-hosted site and import the SQL may be a little challenging. If you need help with that, the WordPress.ORG forum is a great place to start: https://wordpress.org/support/

  • The topic ‘SQL Backup File From Self-Hosted Website to XML File’ is closed to new replies.