On Sun, 15 Aug 2010, Agnello George wrote: > To: CentOS mailing list <centos@centos.org>, li...@yahoogroups.com > From: Agnello George <agnello.dso...@gmail.com> > Subject: [CentOS] best ways to do mysql backup > > we have multiple servers approx 10 and each has about 100 GB of data in > the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we > take backup for these databases on to a remote machine and store them > datewise , ( the remote machine is a 2TB HDD ) > > currently tar is not feasible as the data is too huge and the same goes > with mysqldump > > suggestion will be of great help
Would there be some way of tee-ing off the SQL statements to a remote file in real-time? So in effect you are creating a text file dump of the databases in real-time? Kind Regards, Keith Roberts ----------------------------------------------------------------- Websites: http://www.php-debuggers.net http://www.karsites.net http://www.raised-from-the-dead.org.uk All email addresses are challenge-response protected with TMDA [http://tmda.net] ----------------------------------------------------------------- _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
