Split WordPress XML files for upload to servers

Aug 08, '13 07:30:00AM

Contributed by: kirkmc

I've been doing some work on my website, Kirkville, changing to a new theme. In order to test the theme, I set up a staging server, and wanted to import my existing posts, comments, etc. so I could fiddle with the new theme.

I'm not SQL-savvy, so it seemed the best bet was to use WordPress's export/import feature, through its wordpress-importer plugin. This requires exporting an XML file of the WordPress content from the current server, then importing it on the staging server. Unfortunately, I was hit by that problem where my hosting company has uploads limited to 8 MB, and my WordPress XML file was 10.9 MB.

When I went looking for solutions, I found a number of posts on the WordPress forum suggesting splitting the XML file. I wasn't sure how to do this safely, but found a free Mac utility called WXR Splitter. Running this tool, I split the XML file into two pieces, with a maximum of 6 MB each. I was able to upload the XML file, and get to work with my new theme.

Comments (1)


Mac OS X Hints
http://hints.macworld.com/article.php?story=20130808021620500