Replication as Simon suggested. 250GB is a lot of data to risk sending via mysqldump on a standard UG-type link.
Paul. On Dec 03, 2012, at 16:07, [email protected] wrote: > 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. > _______________________________________________ > 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.
