I think mysqldump and some clever piping might do what you want. Depending on your connection stability you may want to dump to files first, though, as the risk of an incomplete yank (opposite of dump) goes down.
Joshua Mpairwe <[email protected]> wrote: >Hello LUGz, I have a MySQL database already in use about 250G sitting >on a >LAN server. Now I would like to have a replication tool that is able to >replicate the database on the LAN to a similar database ONLINE. I do >not >want to keep going to through cPanel as this would be tendious. Which >proven tools/software would you recommend, preferrably open sources? >Help will be greatly appreciated. > >-- >Mpairwe Joshua >Web Developer > > >------------------------------------------------------------------------ > >_______________________________________________ >The Uganda Linux User Group: http://linux.or.ug > >Send messages to this mailing list by addressing e-mails to: >[email protected] >Mailing list archives: http://www.mail-archive.com/[email protected]/ >Mailing list settings: http://kym.net/mailman/listinfo/lug >To unsubscribe: http://kym.net/mailman/options/lug > >The Uganda LUG mailing list is generously hosted by INFOCOM: >http://www.infocom.co.ug/ > >The above comments and data are owned by whoever posted them (including >attachments if any). The mailing list host is not responsible for them >in any way.
_______________________________________________ The Uganda Linux User Group: http://linux.or.ug Send messages to this mailing list by addressing e-mails to: [email protected] Mailing list archives: http://www.mail-archive.com/[email protected]/ Mailing list settings: http://kym.net/mailman/listinfo/lug To unsubscribe: http://kym.net/mailman/options/lug The Uganda LUG mailing list is generously hosted by INFOCOM: http://www.infocom.co.ug/ The above comments and data are owned by whoever posted them (including attachments if any). The mailing list host is not responsible for them in any way.
