WordPress.org

Support

Support » How-To and Troubleshooting » WordPress export renders sql file

WordPress export renders sql file

  • I have a blog which i need to move to a multisite, but using the export tool on wordpress delivers a sql file instead of a wrx file.
    A sql dump of the blog is 20MB and there is around 2GB of media attached to the 1600 posts.

    I have done a mysqldump and done a clean install with the dump and the I did the export which works, but this is causing a whole host of issues with multisite import of that specific site.

Viewing 14 replies - 1 through 14 (of 14 total)
  • esmi

    @esmi

    Forum Moderator

    using the export tool on wordpress delivers a sql file instead of a wrx file.

    Which plugin are you using?

    I’m not using a plugin. Im using the local export/import functionality under tools of wordpress

    Im using the local export/import functionality under tools of wordpress

    WordPress doesn’t export as SQL, It sounds like your server or browser is interprating the file as a sql file rather than as the wxr fileformat that it might not understand.

    Blogs on the same server and wordpress version exports correctly. The file that starts downloading is not a wrx file, it looks like a mysql dump

    esmi

    @esmi

    Forum Moderator

    The native import/export in WordPress requires a plugin and has done for some time now. Have you actually checked the file to see if it’s a true .sql file or an .xml file?

    # WordPress MySQL database migration
    # From http://blog.mydomain.co.za to http://blog.mydomain.co.za.dedi254.cpt1.host-h.net
    #
    # Generated: Friday 3. June 2011 06:20 UTC
    # Hostname: dedi254.cpt1.host-h.net
    # Database: mydomain_blog
    # ——————————————————–

    # ——————————————————–
    # Table: wp_commentmeta
    # ——————————————————–

    This is how the file looks

    esmi

    @esmi

    Forum Moderator

    What import/export plugin are you using

    Im using the local export/import functionality under tools of wordpress

    esmi

    @esmi

    Forum Moderator

    Please see my earlier post.

    # WordPress MySQL database migration

    That export format is generated by the following plugin: http://wordpress.org/extend/plugins/wp-migrate-db/

    You’ll need to use the Tools -> Export functionality to create a WXR export which WordPress can import into the multisite instance correctly.

    The import requires a “WordPress” plugin install, but not the export. Even after I have install the plugin and do the export, a sql file is being downloaded

    I’m not using the wp-migrate-db plugin, but it does seem to effects the export. After i removed the wp-migrate-db plugin, i get a black page with hello world on it when i click export.

    esmi

    @esmi

    Forum Moderator

    If you are not going to actually read the support being offered – including assistance from a WordPress core developer – there really isn’t any point in this thread continuing.

    Thanks for all the help, much appreciated!

Viewing 14 replies - 1 through 14 (of 14 total)
  • The topic ‘WordPress export renders sql file’ is closed to new replies.