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.
Mac OS X Hints