importing a sql.gz file so I can export a .xml file

• 

  villamo545 · Member · Apr 18, 2023 at 8:23 pm

  • Copy link
  • Add topic to favorites

  Hi there, I had a WordPress site for several years and ended up needing to move over to square space. I have a sql.gz backup file and would like to bring my blog posts over to my new site, but apparently can’t do that directly. Is there a way I can import that into WordPress and export it again or at least get a csv file with the urls and text so I can recreate the posts? I’m not sure how that works. Any help you can provide would be much appreciated. Thank you!

  Self-declared URL: no current site
  Jetpack: Unknown
  WP.com: Unknown

  The blog I need help with is: (visible only to moderators and staff)

• 

  villamo545 · Member · Apr 18, 2023 at 9:02 pm

  • Copy link

  never mind! I was able to find an old .xml backup. I don’t see anywhere I can delete my post so thought I’d update.

• 

  supernovia · Staff · Apr 19, 2023 at 9:39 am

  • Copy link

  Hi @villamo545! Glad you’ve got it. Yeah, with a SQL backup, your best bet will be to install a copy of WordPress, then import into that. Then export.

  You’ll also want to mind that your images get imported, though.

  Good luck!