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 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 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 > > ------------------------------------------------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: 5/23/2007 3:59 PM >