Re: [CentOS] best ways to do mysql backup

2010-08-16 Thread Matt
> currently tar  is not feasible as the data is too huge  and  the same goes > with mysqldump > > suggestion will be of great help Not really an answer but a good book on the subject: http://oreilly.com/catalog/9780596807290/ http://oreilly.com/catalog/9780596101718/ Matt __

Re: [CentOS] best ways to do mysql backup

2010-08-15 Thread Jerry Franz
On 08/15/2010 09:49 AM, n...@li.nux.ro wrote: > Tuptus writes: > > >> Nic by się nie stało gdyby Agnello George nie napisał: >> >>> 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 >>> w

Re: [CentOS] best ways to do mysql backup

2010-08-15 Thread nux
Tuptus writes: > > Nic by się nie stało gdyby Agnello George nie napisał: >> 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 s

Re: [CentOS] best ways to do mysql backup

2010-08-15 Thread Tang Jianwei
why not mysqldump + binlog + rsync? Tang Jianwei On 08/15/2010 03:51 AM, Agnello George wrote: 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

Re: [CentOS] best ways to do mysql backup

2010-08-15 Thread Tuptus
Nic by się nie stało gdyby Agnello George nie napisał: > 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 , (

Re: [CentOS] best ways to do mysql backup

2010-08-14 Thread Jerry Franz
On 08/14/2010 03:58 PM, John Hinton wrote: > > For uninterrupted delivery of dynamic content from the database... or no > downtime, replication to a slave is the way to go. This is 'sort of' a > T-ing effect, except it is to another database. That slave database > however can be stopped, a mysgldum

Re: [CentOS] best ways to do mysql backup

2010-08-14 Thread John Hinton
Keith Roberts wrote: > On Sun, 15 Aug 2010, Agnello George wrote: > > >> To: CentOS mailing list , li...@yahoogroups.com >> From: Agnello George >> Subject: [CentOS] best ways to do mysql backup >> >> we have multiple servers approx 10 and each has

Re: [CentOS] best ways to do mysql backup

2010-08-14 Thread Keith Roberts
On Sun, 15 Aug 2010, Agnello George wrote: > To: CentOS mailing list , li...@yahoogroups.com > From: Agnello George > 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 , excludi

Re: [CentOS] best ways to do mysql backup

2010-08-14 Thread Markus Falb
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/08/2010 21:51, Agnello George wrote: > 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 machi

Re: [CentOS] best ways to do mysql backup

2010-08-14 Thread Benjamin Franz
On 08/14/2010 12:59 PM, Benjamin Franz wrote: > On 08/14/2010 12:51 PM, Agnello George wrote: > >> 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

Re: [CentOS] best ways to do mysql backup

2010-08-14 Thread Benjamin Franz
On 08/14/2010 12:51 PM, Agnello George wrote: > 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 remo

[CentOS] best ways to do mysql backup

2010-08-14 Thread Agnello George
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 feasibl