WordPress.org

Ready to get started?Download WordPress

Forums

WordPress export renders sql file (15 posts)

  1. petrivoges
    Member
    Posted 2 years ago #

    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.

  2. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

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

    Which plugin are you using?

  3. petrivoges
    Member
    Posted 2 years ago #

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

  4. Dion Hulse
    WordPress Dev
    Posted 2 years ago #

    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.

  5. petrivoges
    Member
    Posted 2 years ago #

    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

  6. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

    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?

  7. petrivoges
    Member
    Posted 2 years ago #

    # 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

  8. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

    What import/export plugin are you using

  9. petrivoges
    Member
    Posted 2 years ago #

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

  10. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

    Please see my earlier post.

  11. Dion Hulse
    WordPress Dev
    Posted 2 years ago #

    # 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.

  12. petrivoges
    Member
    Posted 2 years ago #

    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

  13. petrivoges
    Member
    Posted 2 years ago #

    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.

  14. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

    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.

  15. petrivoges
    Member
    Posted 2 years ago #

    Thanks for all the help, much appreciated!

Topic Closed

This topic has been closed to new replies.

About this Topic