[MySQL Synchronization]

I have a MySQL database (DB_WEB) in Web which is the primary database contains data of different Branch Offices (BO). Every job is done on DB_WEB itself.

 

Now for some reason, I need to do some work on Branch Office Database say DB_BO1. How do I update the DB_WEB when I connect to Web provided it updates only the data for BO1 only.

 

Similarly, how the data from DB_WEB updates the data in the DB_BO1.

 

The web application is written in PHP where as local aplication is written in VB6.

 

I need a complete suggestion.

[MySQL export/import problems]

I have five MySQL databases located in five different locations(Branch Offices) and one centralised MySQL database in HO(Head Office). I have to transfer data from all these five databases to centralised database, provided the old data in the centralised database should not be affected. And what is the way of transfering the data from BO to HO? The data transfer is not done by lease line connection.

[transferring data from one mysql database to another]

How do I transfer particular records (say 10 records out of 100) which are updated in one database(say DB1, or DB2) to another one(say DBMain).

 

The DBMain database contains data from DB1, DB2 and DB3. The rest of the data should not affected.

 

I tried phpMyAdmin, but it does not solve my problems.