OS X and MySQL Data

I’ve got Local running on an external hard drive and all of the site files are on it. I then also used the same external drive to setup my Local development environment using my laptop on the go.

Ideally, I just want to plugin the external drive and start Local. I’m running into a problem with the database however.

While all of the site file are kept up to date on the drive, the MySQL database continues to reflect the computer I’ve got the drive attached to as it doesn’t see recent updates made on another machine.

I’ve tried to locate the MySQL data as it seems like it must be running on each Mac’s internal hard drive but I just can’t seem to find it. I’ve checked the hidden places it’s supposed to be, but I’m not seeing it.

So my questions…

  1. Could someone help me with aiding me in locating where the MySQL data is being housed on each Mac?

  2. How can I make it so the MySQL database files are running from the external hard drive?

Does anyone out there know the answer to this question?