Title: WordPress export renders sql file
Last modified: August 20, 2016

---

# WordPress export renders sql file

 *  [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/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](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165675)
 * > using the export tool on wordpress delivers a sql file instead of a wrx file.
 * Which plugin are you using?
 *  Thread Starter [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165680)
 * I’m not using a plugin. Im using the local export/import functionality under 
   tools of wordpress
 *  Moderator [Dion Hulse](https://wordpress.org/support/users/dd32/)
 * (@dd32)
 * Meta Developer
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165691)
 * > 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.
 *  Thread Starter [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165696)
 * 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](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165697)
 * 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?
 *  Thread Starter [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165704)
 * # WordPress MySQL database migration
    # From [http://blog.mydomain.co.za](http://blog.mydomain.co.za)
   to [http://blog.mydomain.co.za.dedi254.cpt1.host-h.net](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](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165723)
 * What import/export plugin are you using
 *  Thread Starter [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165724)
 * Im using the local export/import functionality under tools of wordpress
 *  [esmi](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165727)
 * Please see my earlier post.
 *  Moderator [Dion Hulse](https://wordpress.org/support/users/dd32/)
 * (@dd32)
 * Meta Developer
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165729)
 * > # WordPress MySQL database migration
 * That export format is generated by the following plugin: [http://wordpress.org/extend/plugins/wp-migrate-db/](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.
 *  Thread Starter [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165730)
 * 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
 *  Thread Starter [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165740)
 * 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](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165742)
 * 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.
 *  Thread Starter [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * (@petrivoges)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165743)
 * 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.

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [wrx](https://wordpress.org/support/topic-tag/wrx/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 14 replies
 * 3 participants
 * Last reply from: [petrivoges](https://wordpress.org/support/users/petrivoges/)
 * Last activity: [14 years, 11 months ago](https://wordpress.org/support/topic/wordpress-export-renders-sql-file/#post-2165743)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics