[General] mysql sync

[Eng. Sabah Al-Sabah]

Will this help:

http://www.wellho.net/solutions/mysql-replicating-servers-in-mysql-why-and-h
ow.html

 

 

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
that?



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
http://mail.oskw.org/mailman/listinfo/general_oskw.org








 



  _____  



 
_______________________________________________
General mailing list
General at oskw.org
http://mail.oskw.org/mailman/listinfo/general_oskw.org
  

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