[General] mysql sync

[Bashar Al-Abdulhadi]

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,


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://oskw.org/pipermail/general_oskw.org/attachments/20070408/07e9bf16/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3249 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://oskw.org/pipermail/general_oskw.org/attachments/20070408/07e9bf16/attachment.bin>