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 X …

Source: Mac OSX Hints