RE: time taken by mysqldump

2007-05-24 Thread Tim Lucia
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, >

Re: time taken by mysqldump

2007-05-24 Thread Ananda Kumar
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

Re: time taken by mysqldump

2007-05-24 Thread B. Keith Murphy
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