I have MAMP Pro installed on three computers: one at work and two at home. I'd like to be able to keep my MAMP installs synced. Is there a way to sync the databases (using dropbox, perhaps)?
Sync MAMP Install Over Multiple Macs
(2 posts) (2 voices)-
Posted 8 years ago Permalink
-
I'm not aware of an "easy" way to do this, but I've used rsync to achieve this in the past, but there are a lot of permission issues to work with the data.
There's another way too; there's a ruby gem that can help these sync issues called taps (http://rubygems.org/gems/taps) which is used by the awesome folks at heroku to sync your database with the one in production. You could set up a script that would do something along these lines on each of the servers running mysql:
taps server mysql://localdbuser:localdbpass@localhost/dbname?encoding=latin1 httpuser httppassword
Then, to pull the copy of the database, you can do this:
taps pull mysql://localdbuser:localdbpass@localhost/dbname http://httpuser:httppassword@example.com:5000
and push your updates
taps push http://httpuser:httppassword@example.com:5000 http://httpuser:httppassword@example.com:5000
If you've not run any ruby stuff on your mac, make sure you update rubygems before you try this out with
sudo gem update --system
Then install the taps gems with
sudo gem install taps
Posted 8 years ago Permalink
Reply
You must log in to post.