The only database I've seen that could handle synchronizing disconnected databases is Oracle - a number can do replication which is a bit simpler. Its not hard if you have a very simple, or single, table structure; after all, that's what all the PDA synch stuff does. But when you get into more complex data models you have to deal with all sorts of potential referential integrity issues. For example, someone deletes a parent record on the server which invalidates an edited child record on your laptop version. Even the PDA synch run into problems when one person changes part of an integral record, say a meeting description, and another person changes the another part, say the time. Which record do you take, or do you try to merge the two? If the data structure is simple enough, and you are the only one making changes, you can probably use table triggers to write SQL statements to a log table. Then you apply the statements to the database you want to synch, but even then there are a bunch of gotchas and I don't recall if MySQL supports triggers in the current version. Good luck. --rick Keith Bachman wrote: >Got a question for you mysql experts/gurus/whatevers out there. > >I'm looking at using dotproject (www.dotproject.net) for a task >management system, and plan on running it on my laptop (under Windows >XP Pro, I know) in WAMP, for when I'm on the road, no net access. >However, I also want it on my site for when I don't have my laptop (or >so others can have access) but I don't own the server my site sits on >(hosting company) > >The question is this: > >Is it possible for me to (maybe using transaction logs? I don't know, >haven't used mysql, just sql) replicate the data between two mysql >servers, that aren't always able to talk to each other? > >And for bonus brownie points, is it easily scriptable? > >Thanks in advance, > >Keith Bachman > >_______________________________________________ >TCLUG Mailing List - Minneapolis/St. Paul, Minnesota >Help beta test TCLUG's potential new home: http://plone.mn-linux.org >Got pictures for TCLUG? Beta test http://plone.mn-linux.org/gallery >tclug-list at mn-linux.org >https://mailman.real-time.com/mailman/listinfo/tclug-list > > _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota Help beta test TCLUG's potential new home: http://plone.mn-linux.org Got pictures for TCLUG? Beta test http://plone.mn-linux.org/gallery tclug-list at mn-linux.org https://mailman.real-time.com/mailman/listinfo/tclug-list