It's probably easier to resync the whole database to the laptop, than try to do two-way updates -- unless it's very hard to copy the datafiles from the central database.
You can use the binary logging facility of MySQL to keep track of changes on the laptop and then update those changes to the central database -- as long as the changes on the laptop don't conflict with other changes someone else may make on your central database. See the doc: http://www.mysql.com/doc/B/i/Binary_log.html --jeff ----- Original Message ----- From: "Bram Vaessen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 01, 2002 6:49 PM Subject: 2 seperate mysql-servers cooperate??? > 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 > --------------------------------------------------------------------- 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
