Support » How-To and Troubleshooting » Sql.gz to WXR conversion

Sql.gz to WXR conversion

  • Hi,

    All our backups are from a previous version of WordPress, ending in sql.gz

    We no longer have any access to this previous WP version as we’ve just switched hosting providers. Upon setting up the new WP system, it’s only offering us the ability to restore from backup files ending in WXR.

    Is there a conversion routine out there or can anyone assist PLEASE as our company blog has been down for a week now and people are getting twitchy!

    Thanks in advance.


    P.S. We are also not able to install a previous version of WP, get the plug-in and export in WXR format just in case this was a potential solution.

Viewing 5 replies - 1 through 5 (of 5 total)
  • the solution is to import the sql.gz into the database

    Samuel, when we try to import the backup in to our new WP database, the only option we are given is to restore a WXR file, not sql.gz



    ok – did you even read my link?
    you will NOT be using wordpress’ dashboard for this

    Hi Samuel, we’ve followed the steps in the post you pointed us to and found that the imported tables(?) are renamed and prefixed with the letters ai. For example there is a table in the fresh install named wp_posts, when we import our backup this table is named aiwp_posts. If we then delete wp_posts and rename aiwp_posts to wp_posts this screws up the database and all we get when viewing the blog is a blank screen.

    no sweat – that just means you need to open wp-config.php and find
    $table_prefix = 'wp_';
    and change it to
    $table_prefix = 'aiwp_';

    then do the import

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Sql.gz to WXR conversion’ is closed to new replies.