[BNM] synchronise two mysql dbs

[Alan Newman]

Hi,

MySQL 5 has 'full on' replication - if that helps.

What version are you using?

- Alan


-----Original Message-----
From: Nick Wilsdon [mailto:n.wilsdon at e3internet.com]
Sent: 04 September 2006 11:22
To: 'Brighton New Media'
Subject: [BNM] synchronise two mysql dbs


Hi,

I'm trying to find a script that will synchronise our local application with
a copy on the server. Both boxes are *nix (RHE/Ubuntu)

SQLyog (http://www.webyog.com/en/) looks pretty good but the problem is that
we enter data on both apps. Unless I'm reading it wrong, SQLyog seems to
synchronise the source to the target DB by deleting any additional rows on
the target, rather than merging them?

Has anyone heard of something that would do that job?

Best Regards,

Nick

Managing Director
e3internet
http://www.e3internet.com



--

BNM info/subscription/archives: http://www.brightonnewmedia.org/

BNM archive search: http://www.roddis.org/bnm/search.php
BNM Del.icio.us tag: http://del.icio.us/tag/bnm/
BNM Flickr group: http://www.flickr.com/groups/bnm/

BNM powered by http://www.screen-play.net/