Sql.gz to WXR conversion (6 posts)

  1. perceptant.com
    Posted 4 years ago #


    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.

  2. Samuel B
    Posted 4 years ago #

    the solution is to import the sql.gz into the database

  3. perceptant.com
    Posted 4 years ago #

    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



  4. Samuel B
    Posted 4 years ago #

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

  5. perceptant.com
    Posted 4 years ago #

    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.

  6. Samuel B
    Posted 4 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic