Hi ,

I am currently thinking about a way of effectively syncing mysql-databases.

A short introduction:

Right now I program a web-based frontend for a mysql database, where you can
store information, update tables etc, just what you do with a php/mysql database
solution. (I am running Slackware 9.0, Apache 2.0.48, PHP 4.3.4, MySQL 4.0.1.6).

Whenever the client is connected to the network, he works on the server,
http://server/database/index.php and does everything on the remote mysql database.

But whenever he travels, he has a local copy of this web-frontend on his computer,
and works on the local mysql database (which he can copy before he travels, without
a problem to his computer)

---

Now there is an interesting question:
In the time when he is on his journey, he does not connect to the server database via
internet, but works on his own local database, adds new data, changes data etc.
The same happens at the same time on the server, where someone else adds data
and changes something.

Now when he comes back "home" he wants to sync the data of his local database with
the server database.

My question now is: How is it possible to sync data in the way I just described, when you
are working on a mysql database solution?

Simply copying the database to the server would overwrite the other database completely.

I have been thinking about this for some time, but I am still sitting here with nothing...


What to you think would be able to do this job?

Thanks in advance, I hope you can help me cause I am lost in a dead end

-shad