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
Hi All,
We have database of around 100GB, and planning to take dump using mysqldump.
Can you please let how much time it would take for 100GB.
We have 8GB RAM and 4 intel latest processor. The mysql db is running on
linux.
regards
anandkl