[CentOS] best ways to do mysql backup

[Keith Roberts]

On Sun, 15 Aug 2010, Agnello George wrote:

> To: CentOS mailing list <centos at centos.org>, linux at yahoogroups.com
> From: Agnello George <agnello.dsouza at 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]
-----------------------------------------------------------------