I'm developing dynamic websites running on local PCs under XAMPP (until ready to upload to production server).
PC1 OS: Win XP MCE v2002 SP3
PC2 OS: Win XP MCE v2002 SP3
LAN: MS Windows Network
In general I develop on PC1 and sync the website files across the LAN to PC2. I use something as simple as SyncToy to sync the website files. Works fine.
Another user can test the site on PC2 and inform me of required changes. The user on PC2 might make additions/deletions to the tables in the DB (but the individual DB name and access parameters are duplicated across both machines so that doesn't change)
Not sure where the MySQL database files which pertain to a given site are stored in XAMPP. Searching in the obvious places doesn't turn them up. I can 'see' the DBs in localhost/phpMyAdmin but don't know where they are stored on the PC (I know ... sounds really lame).
I can export a given DB, say from PC1 using phpMyAdmin, and import it into PC2 using its phpMyAdmin but this is kludgy and requires me hopping around between PCs.
How can I sync a MySQL DB across two PCs on my LAN?
If I can sync both ways across both PCs great but I'll settle for just being able to conveniently transfer the MySQL DB from PC1 to PC2 without having to go through the phpAdmin export/import dance every time.
There are commercial packages out there pertaining to do this but I'm looking for an open-source (free) solution at the moment.
Thx for your help.
I want a