On Sun, 15 Aug 2010, Agnello George wrote:
> To: CentOS mailing list <centos@xxxxxxxxxx>, linux@xxxxxxxxxxxxxxx
> From: Agnello George <agnello.dsouza@xxxxxxxxx>
> Subject: 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@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
