I'm trying to move to a new server. I export all my entries from the old server, which is a Berkeley DB installation, and ftp the file to the new one, in ASCII mode (obviously). The new server runs MySQL.

After a few hiccups, I finally get through the import of 1800 entries and 3000 comments, more or less. When I do the rebuild, the individuals, indexes, and weeklies build fine, but the monthlies and categories will both die with error 500.

I've experimented with partial imports, because I can't get though the whole import without the import process stopping mid-way through, and I've looked at the export/import file in some detail.

The problem seems to be caused by some bad entries in this file. So the question is, does anyone have a utility that can inspect an export/import file and flag bad entries?

I have another, smaller blog moved over just fine.