I have been fighting with my shared host support team to get them to make an exception in my case to suspend the PHP resource limits, so that I can load my 40M XML file into my new WP2.6.3 self-hosted blog.
After finally getting them to agree, it turns out that the frickin' XML file was corrupt. Apparently, there wasn't an proper closure of the file (?) or EOF or something? They tell me that not all of my posts made it into the backup file. I've run the export process several times to confirm and the same thing happens over and over again.
Could I get WP.com to export the file for me and check it's integrity? Is there a way to split that file up into multiple, smaller <20M files?
If I edit the file myself, what are the closing XML tags after the last </item>?
Does it matter if I reload the category tags multiple times, i.e. will existing categories be wiped or will the import process skip over existing data? What about the tags? I see that some tags are just numbers e.g. 7896565?
I really need help on this as I pushed the big red button with the other support team only to find that "I" wasn't prepared.