[General] mysql sync

Eng. Sabah Al-Sabah sabah at techsys.net
Mon Apr 9 13:32:32 +03 2007

Will this help:




Best Regards,


Eng. Sabah Al-Sabah

General Manager

Technical Systems Est.

sabah at techsys.net

www.techsys.net <http://www.techsys.net/> 



From: general-bounces at oskw.org [mailto:general-bounces at oskw.org] On Behalf
Of Bashar Al-Abdulhadi
Sent: 08 أبريل, 2007 02:27 م
To: General OpenSource Discussion
Subject: Re: [General] mysql sync


W'Salaam El-Semmi :)


batch script for large changes kinda a killer especially the two servers are
very far, one hosted at kuwait on 256k dsl and the other at my datacenter in
the US, thats why i thought of someway of inserting SQL queries for changed
entries only not the entire db.



bashar abdullah wrote:

Salam Bashar,

I'm sure you have thought about it, but why isn't a batch script good for

On 4/8/07, Bashar Al-Abdulhadi < bashar at kuwaitnet.net
<mailto:bashar at kuwaitnet.net> > wrote: 

Salaam All,

what is the best way to sync mysql databases by inserting new/changed  data
into remote mysql box?


mysql replication would do it but it needs little changes on the live server
which i dont want to.


was wondering if a way to insert new lines into the remote db every x amount
of minutes or so instead of doing an entire dump and restoring it remotely


any thoughts are much appreciated :)

Best Regards,


General mailing list
General at oskw.org



General mailing list
General at oskw.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://oskw.org/pipermail/general_oskw.org/attachments/20070409/20fd8c19/attachment-0004.html>

More information about the General mailing list