believe.)
BTW, we run the dump off the slave only.
HTH,
Tim
> -Original Message-
> From: Ananda Kumar [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 24, 2007 3:49 AM
> To: B. Keith Murphy
> Cc: MySQL General
> Subject: Re: time taken by mysqldump
>
> Hi Keith,
>
Hi Keith,
I will be doing this from my slave database.
Any rough estimate of time for 100gb mysqldump.
regards
anandkl
On 5/24/07, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
Have you considered replicating to a backup server and then dumping from
it?
No matter your processors with a 100gb db
Have you considered replicating to a backup server and then dumping from
it?
No matter your processors with a 100gb db it is going to take a
significant amount of time.
Keith
Ananda Kumar wrote:
Hi All,
We have database of around 100GB, and planning to take dump using
mysqldump.
Can you