Synchronization of files and mysql on Mac OS

Question

MySQL

I'm a web developer, and lately I've been getting sick of using a flash drive to transfer work files from my work iMac to my home Macbook. I use Dropbox for documents, but what about project files?

XAMPP is installed on both machines, you have to pack files, do a mysql dump and take it on a flash drive or throw it in a dropbox. Then do the reverse process at home.

Can anyone recommend anything to make this routine easier?

Answer 1

For code - any version control system, even the same SVN, or better - Git.
As for mysql, there are several solutions:
1. make a dump in the evening and commit it to the version control system, at home - pull it out and import it into mysql.
2. the same plus console scripts like "dump + commit", "checkout + restore" for automation
3. set up a mysql database on an externally accessible server and use it for both projects (work and home)

Answer 2

start a virtual machine on both machines, configure LAMP there and put the image of the virtual machine itself on a USB flash drive (better an external screw of course) and use it on both machines. I do like this

Answer 3

try phing there are a lot of useful things it saves you from the routine. The truth will take a long time to figure out.