Getting SQL backup for my wordpress.com site

• 

  suavros · Member · May 24, 2014 at 4:28 am

  • Copy link
  • Add topic to favorites

  I need an SQL backup for my wordpress.com site because I am transferring to another host provider and my site will be a wordpress.org site. I tried going the XML route, but Dreamhost needs SQL backup. Any help would be appreciated.

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

• 

  jeremeylduvall · Member · May 24, 2014 at 3:32 pm

  • Copy link

  Hi there,

  Currently, the only way to export your site is through the XML file described here:

  Export your website’s content

  It isn’t possible to generate an SQL backup through WordPress.com. Can you let me know what aspects of your site aren’t getting carried over with the XML format?

• 

  suavros · Member · May 24, 2014 at 8:18 pm

  • Copy link

  Thank you for the prompt reply. Basically, not all of my posts are carrying through. My actual XML file is 216KB. When I go to Tools – Import – WordPress – Choose File – Upload File and Import, I see that not all of my content is transferred. I get the following message:

  Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 239340629 bytes) in /home/suavros/myexcursions.me/wp-includes/class-http.php on line 1462

  and several of my more recent posts are missing.

  The reason why I thought I needed to go the SQL route is because this is what Dreamhost told me they needed.

  Thank you for the continued help.

• 

  jeremeylduvall · Member · May 27, 2014 at 3:02 pm

  • Copy link

  Howdy!

  It sounds like the importer for Dreamhost may be timing out on the large upload. The best way around this would be to break up the file into multiple parts. Can you give that a try? Here are instructions on how to do that:

  1. Export the XML file.
  2. Open the XML file with Notepad or another text editor. Open at least one other instance of Notepad (which will become part 2, etc.)
  3. Copy the XML file headers from the master file. Stop highlighting just before the first tag, and copy this into File Part 2.
  4. Depending on the size of the master, and if you need to break it into 2, 3, 4 pieces, scroll halfway/one-third down the Master file. Find the next tag (do a search) at this point in the Master file. Select and highlight starting from the tag. If dividing the file into two, select until the end of the Master file, copy and paste into File Part 2. Save Part 2 as an .xml file. DELETE the part copied into Part 2 from the Master file. Save Master file.
  5. If dividing into 3 or more parts, for each part highlight approximately 1/3 of the Master file, making sure to BEGIN highlighting with and end with otherwise it will break. You’ll need the xml headers for each Part X file as indicated in Step 3.
  6. After saving the pieces, go to Tools > Import > WordPress and upload each file. The order in which the files are uploaded is not important.

  Basically, instead of uploading one huge file now, you’ll be uploading multiple small ones, which should help to get around the timeout error.