Syncing a WordPress database between XP and Linux?!

A very naive question: I have been using a local version of WordPress on Gentoo for several months now; recently upgraded to WordPress 2.0 with no problems. I dual-boot the machine with XP (I have to have Windows for various work-related reasons), and I would love to be able to have access to the blog on the XP side as well. I do a lot of syncing already with unison for ordinary data files so I can switch between OS’s without a lot of fuss.

As test, I copied over the MySQL database and WordPress install for my blog to the XP partition, set up XAMPP Lite and got everything working. I could see the blog fine, and was able to create a test post in XP no problem.

The next step in the test was to manually copy the database files back to the Linux side, massage the permissions as needed, and then see if the new post showed up. It didn’t! All my old posts were there, but not the new post. It was in the database – I could see it in PhpMyAdmin, and also in WordPress when I went to Manage > Posts – but though I could edit it in WordPress and save it as many times as I wanted, it refused to show up as an actual post.

The versions of MySQl are both 4.1.x, and the MySQL log isn’t complaining of anything.

It may be a doomed, twisted experiment, but is there any way to make this work? There must be something wrong with the database entry as created on XP versus as it would have been created on Linux – yet that seems strange since all the original posts transferred just fine from Linux to XP and survived the return trip as well.

I don’t want to get into dumping the database and recreating it each time I boot from one OS to the other – that’s just too much work for what I want to be a relatively simple process.