Export blog as MYSQL?

• 

  geoffliu · Member · Dec 19, 2012 at 10:38 pm

  • Copy link
  • Add topic to favorites

  Dear WordPress support staff,

  I am trying to export my blog on WordPress.com in MySQL format. The reason for this is that the WXR (.xml) export file is 2.3 MB and my host only allows imports of up to 2 MB.

  Is there any way that I could obtain the MySQL database for my blog?

  Thank you,

  Geoff

  The blog I need help with is: (visible only to logged in users)

• 

  kathrynwp · Staff · Dec 20, 2012 at 4:46 pm

  • Copy link

  While we aren’t able to supply MySQL exports, most hosts do allow you to increase the default 2 MB upload limit on a site-by-site basis, by editing your .htaccess or php.ini file, depending on your server setup.

  You might try looking in your host’s support documentation, or ask your host for specific instructions.

• 

  geoffliu · Member · Dec 20, 2012 at 9:58 pm

  • Copy link

  I eventually solved the issue by going into the WP source code, commenting out a single line of code, and importing my blog little-by-little. Nothing was lost in the process except for feedbacks (which is totally fine, since I have backups of those in my email).

  Thank you!

• 

  kathrynwp · Staff · Dec 20, 2012 at 9:59 pm

  • Copy link

  I’m glad to hear you found a workaround, thanks for letting me know!