[Sussex] MySQL replication

[matthew Macdonald-Wallace]

On Fri, 3 Dec 2004 16:49:17 +0000
Jon Fautley <jon at geekpeople.net> enlightened us with:

> > I'm after a way to basically sync the mysql databases between hosts,
> > however as it is not a permanent connection (the database has a lot
> > of GPS locations on it and the laptop collects more waypoints as I
> > drive around), setting them up as a master and a slave seems
> > excessive.
> >
> > Is there a way of syncing them over ssh or telnet?
> 
> The only problem I see with doing that is that you could end up with 
> data collisions, but as I know what you're doing with your laptop, I'm
> guessing you won't be updating the DB on the desktop? If that's the 
> case, then you could write a little script (probably in Perl, because 
> it rocks) to dump the database to a CSV, then reimport it into the 
> desktop whenever you a) run a command or b) have your GPS reciever 
> detect you're outside your house, logon to the network, sync, then 
> disconnect, or c) (probably easier, not half as geeky tho) wait for it
> to lock onto a wireless network :)

ummm it doesn't really "connect" as such to wireless networks...

Cheers, I'll give the perl thing a go...

Matt

--
+-------------------------------+
| Matthew Macdonald-Wallace     |
| matthew at truthisfreedom.org.uk |
| www.eighthnerve.co.uk         |
+-------------------------------+


This email has been independently scanned for viruses and any virus detected has been removed using McAfee anti-virus software