[CentOS] best ways to do mysql backup
Benjamin Franz
jfranz at freerun.comSat Aug 14 19:59:55 UTC 2010
- Previous message: [CentOS] best ways to do mysql backup
- Next message: [CentOS] best ways to do mysql backup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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. -- Benjamin Franz
- Previous message: [CentOS] best ways to do mysql backup
- Next message: [CentOS] best ways to do mysql backup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list