I want to share a MySQL database between two installations of PHP and MySQL on two different machines running at different times. Basically, I want a Wiki on a stick that I can run on Windows and my iBook. This is easy on Windows - just follow the instructions on the page linked there. Running a wiki on a Mac is unbelievably easy with MAMP.
The problem is pointing the both of them at the same MySQL data so I can update the info in either place. I can change the datadir in the MySQL config in MAMP, but it does me no good - MAMP has to be installed in /Applications/MAMP, or it just doesn't work (it won't even copy into other directories).
So I need to find another solution on the Mac, or a way to point the MAMP install of MySQL at an arbitrary directory. Anyone managed to do this?
Also, a couple notes:
- This isn't a real LazyWeb request, since I've spent about 8 hours dicking around with this over the past few weeks. That's not too lazy....right?
- I know I could just run this on the PC desktop and connect to it like any other website, but I'd like to keep it on the thumb drive if I can.
Any ideas are welcome.