Hi You could handle this problem in a similar manner to the way we handle it for the Sharp Zaurus PDA. We have a synch module which acts a mediator between both the central db and the db on the PDA. In our case the PDA stores info in a flat file system and the synch module maps data between the flat file system on the PDA and the central db server. The synch module is written in C++.
At 03:49 02/03/2002 +0100, Bram Vaessen wrote: >Hi, > >I have the following problem: >I have a database in mysql and a C++ program to manage it. Now some people >need to work in the train or something on their laptop, so I was wondering >if it's possible to put the same mysql-database local on the laptop and let >those people edit it local. >Then when they come back to the office, the changes they made should be >commited to the 'central' database and when that's done the database on the >laptop should also be updated with any changes made on the central database. > >What is the best way to do it??? can I somehow tell the mysql-server to log >all the changes from a certain point and then commit it at some time to the >central database or something??? This should be a common problem but I have >not seen a solution yet... > >Or should I program the c++ client to log all the changes and commit them >later to the central database and after that update the whole thing??? > >anyway I just want to know if this can be done and what way is the best.. > >thanks, > >Bram Vaessen > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Regards John, Former MySQL Developer ----- [EMAIL PROTECTED] http://www.rygannon.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
