[CentOS] best ways to do mysql backup

Sun Aug 15 12:57:17 UTC 2010
Tuptus <tuptus at turox.org.pl>

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 , ( 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

Why not mysqldump?
I suggest mysqldump to local dysk and backup this to remote.
I use it with __bacula__.

-- 
Tuptus