how can I import from wordpress.org sqldump

• 

  yoniplt · Member · Apr 10, 2015 at 10:54 pm

  • Copy link
  • Add topic to favorites

  Hey,
  I have an sqldump db from an old blog I used to have at wordpress.org and I want to import it to wordpress.com.
  I’m asked for a wxr file.
  How can I extract/create a wxr file from my sql?

  Thanx in advance

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

• 

  timethief · Member · Apr 10, 2015 at 10:56 pm

  • Copy link

  You need an XML export file to be able to import https://en.support.wordpress.com/import/

• 

  yoniplt · Member · Apr 10, 2015 at 10:59 pm

  • Copy link

  yes, I know that (wxr is an xml file)
  but how do I get that xml from an sql file?

• 

  timethief · Member · Apr 10, 2015 at 11:02 pm

  • Copy link

  I believe you have to use a WordPress.ORG install first to create the XML file but I tagged this thread for a Staff response. Please subscribe to it so you are notified when they respond. To subscribe look in the sidebar of this thread, find the subscribe to topics link and click it.

• 

  jeremeylduvall · Member · Apr 12, 2015 at 10:44 pm

  • Copy link

  Hi @yoniplt,

  The best way to get the XML export file would be to regenerate the export from the self-hosted site. Is that site still up and running? The MySQL import may leave out some of the content and will not bring images across to your WordPress.com site.

  If you’re unable to get the XML file, I can email you privately to get the MySQL file, convert it, and then send back the XML file. That should at least get us the majority of content from the MySQL file.

• 

  yoniplt · Member · May 2, 2015 at 8:10 am

  • Copy link

  Hi,
  sorry for the late reply.
  The site is down so everything I have left is the sqldump.

  Can you email me at (email visible only to moderators and staff)?
  thanx

• 

  jeremeylduvall · Member · May 2, 2015 at 1:14 pm

  • Copy link

  Done! Let me know if you don’t receive the email