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 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 >> > Assuming you installed using LVM partitions (and that you left space for > snapshots ;) ), stop the database, take a LVM snapshot, restart the > database, rsync the mysql data directory to the other machine, then > release the snapshot. > Correction: rsync the *snapshot* of the mysql data directory to the other machine. -- Benjamin Franz _______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos