I'd like to use in both Ubuntu and Windows (dual boot) my MySql database files residing on a NTFS partition. Will it work? Any gotchas?
Yes, it works but with some quirks. MySQL uses the same fileformats across platforms so all you need is to share the data directory. One problem is that the data directory need to have mysql as owner and group in ubuntu. And Windows is case-insensitive and Linux is case-sensitive so keep all names uniform: either the whole name lowercase or uppercase but do not mix them.
From start to finish; if you already have things set up this might need some tweaking to fit your setup:
Compiled from topic 1442148 on UF.org.
I got the Ubuntu version working; so partly untested since I do not have Windows
If you have added a linux partition to a previously windows-only environment, you can use the database in place with only some minor tweaks. Long version here, short version:
In order to get around innodb's log size checking, you'll need to move the innodb logs for the ubuntu partition. In