Can I Share MySql Database Files With Windows On Dual Boot?
Answer : 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: Install and setup MySQL on both systems. Stop the mysql server if it is running. Make a new NTFS partition. Mark the device name (let's call it sdXN for now). Move the mysql data directory from Ubuntu to the new partition. mkdir /{mountpoint}/mysql_data sudo mv /var/lib/mysql /{mountpoint/mysql_data using mv saves permissions. Make a new mysql directory sudo mkdir /var/lib/mysql Mount the NTFS partition at /var/lib/mysql . Change the devicename to what it got when you created the NT...
