but perhaps
> 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 t
: 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
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 dum
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
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: http://list
