qeng
asked on
How to Sync MySQL DB Across 2 PCs on LAN
Background:
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.
Question:
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
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.
Question:
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
dianthonym,
Am in the process of trying the Navicat approach, but could use your help with the issue of where the heck those MySQL DBs hide.
The first place I had looked before posting was c:\xampp\mysql\data but as you can see from the attached screen grabs it only contains 2 of the 30 or so DBs presently on my PC.
If you compare the screen grab which shows the files in c://xampp/mysql/data with the one from http://localhost/phpmyadmi
Where are those DBs? I didn't do anything differently when I was creating those sites. I also do not recall updating XAMPP or doing anything which should/could have cause this.
Really puzzled.
Thx for your help by the way. Much appreciated.
c-xampp-mysql-data.jpg
http-localhost-phpmyadmin.jpg
Am in the process of trying the Navicat approach, but could use your help with the issue of where the heck those MySQL DBs hide.
The first place I had looked before posting was c:\xampp\mysql\data but as you can see from the attached screen grabs it only contains 2 of the 30 or so DBs presently on my PC.
If you compare the screen grab which shows the files in c://xampp/mysql/data with the one from http://localhost/phpmyadmi
Where are those DBs? I didn't do anything differently when I was creating those sites. I also do not recall updating XAMPP or doing anything which should/could have cause this.
Really puzzled.
Thx for your help by the way. Much appreciated.
c-xampp-mysql-data.jpg
http-localhost-phpmyadmin.jpg
ASKER
angellll,
Please DO NOT DELETE this question.
If you'll note, I'm still waiting on a reply from the expert community. I would like to synchronize some DBs but can't find where they are created/stored on my PC (as ridiculous as that seems).
Please DO NOT DELETE this question.
If you'll note, I'm still waiting on a reply from the expert community. I would like to synchronize some DBs but can't find where they are created/stored on my PC (as ridiculous as that seems).
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
please check out the mysql's base folder setting, and if there is any innodb tablespace created...
ASKER
I'm not sure what you mean by 'mysql's base folder setting'.
The DBs do exist since I work with the sites on a regular basis on my PC (localhost) under an XAMPP install.
I would have thought the DBs would be stored somewhere in the:
c:/xampp/mysql folder.
See a screngrab of what that folder contains. Is that where I should be looking for all of the DBs which pertain to my multiple sites and if so which subfolder because I can't find anything resembling a DB (or the tables) in those subfolders except for one or two of my sites (which makes it even more intriguing ... if there were none I might understand they are elsewhere but why would there be a couple ... where are the 26 or so other DBs???)
c-xampp-mysql.jpg
The DBs do exist since I work with the sites on a regular basis on my PC (localhost) under an XAMPP install.
I would have thought the DBs would be stored somewhere in the:
c:/xampp/mysql folder.
See a screngrab of what that folder contains. Is that where I should be looking for all of the DBs which pertain to my multiple sites and if so which subfolder because I can't find anything resembling a DB (or the tables) in those subfolders except for one or two of my sites (which makes it even more intriguing ... if there were none I might understand they are elsewhere but why would there be a couple ... where are the 26 or so other DBs???)
c-xampp-mysql.jpg
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx angellll,
Seemed i had to dig a lot to find something quite simple!?
For my reference:
The location where the MySQLs are stored is defined in:
Not sure why one of those DBs show up in C:\xampp\mysql\data. Maybe I exported it there at some earlier time.
Seemed i had to dig a lot to find something quite simple!?
For my reference:
The location where the MySQLs are stored is defined in:
C:\Program Files\MySQL\MySQL Server 5.1\my.iniin #SERVER SECTION under #Path to the database root:
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"That file contains all of the MySQL databases for my sites.
Not sure why one of those DBs show up in C:\xampp\mysql\data. Maybe I exported it there at some earlier time.
ASKER
For my info, where are MySQL DBs stored in an XAMPP environment.? It's bugging me not to be able to find them on the HD.