: David Campbell ; MySql
Sent: Wednesday, November 28, 2007 2:55 AM
Subject: Re: preferred way to backup a 20GB MySQL database
I would echo what Dan says. In addition, from the slave server, you
might look at running the new mysql-parallel-dump tool that Baron
Schwartz has developed
there is something I should know...?
Thanks
Jonathan Trahair
- Original Message -
From: B. Keith Murphy
To: Dan Buettner
Cc: David Campbell ; MySql
Sent: Wednesday, November 28, 2007 2:55 AM
Subject: Re: preferred way to backup a 20GB MySQL database
I would echo what Dan says
Hi,
What is the preferred way to backup a 20GB database daily,
without taking offline ?
MySQL 4.1 MyISAM - (will be updated to MySQL 5)
133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB
Thanks,
Andras
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Andras Kende wrote:
Hi,
What is the preferred way to backup a 20GB database daily,
without taking offline ?
MySQL 4.1 MyISAM - (will be updated to MySQL 5)
133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB
Mysqlhotcopy
--
MySQL General Mailing List
For list archives:
I'd strongly recommend setting up replication, and then taking your backups
from the replica.
mysqlhotcopy works great, I used it for years myself, but it does require
freezing your database while the copy happens. And no matter how you do
it, copying 20 GB takes a little bit of time.
Dan
On
I would echo what Dan says. In addition, from the slave server, you
might look at running the new mysql-parallel-dump tool that Baron
Schwartz has developed. It essentially does a dump with a thread
running (by default) for each CPU core you have. A dual core box will
run two threads and