I currently have 2 PC's, both set up with Xampp installed. I would like both to use the same database to update from either PC. Currently I am doing a copy of the databases (xampp/mysql/data) from the main pc to my 2nd pc each day to keep them updated in sync. What I would like to do is use a single set of the databases on a NAS drive, so both PC's can access and update the same data to eliminate my having to do the copies.
I have moved the databases to a share on my WD NAS drive, and changed the datadir option on the my.ini file to the NAS drive using both the network and mapped drive letter paths. However, with the datadir pointing to the NAS Share, when restarting mysql from the console, it begins to start display the PID, however apparently when assigning the port, it then fails.
Changing the datadir in my.ini back to the xampp folder after moving the databases back, then mysql starts fine. I have tried it with the databases on the NAS drive, in both a public share and private share on the NAS with user security and neither will allow mysql to load.
One of my PC's is running windows 8.1 and the other windows 7 home premium, both networked using HomeGroup, through a NetGear Router. I can share files between both PC's and the NAS drive fine, but I just cannot get xampp to run mysql with the databases on the NAS. Any thoughts?