The MySQL Administration backup routine is just a front end for mysqldump On Nov 28, 2007 12:51 AM, J Trahair <[EMAIL PROTECTED]> wrote:
> What about the MySQL Administration backup routine, which can be scheduled > for a convenient time? No-one has mentioned this one. We use it 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 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. 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 dump roughly twice as fast as a normal mysqldump. > In addition, it compresses the output making it much more compact. He > has renamed the toolkit to Maatkit and it is available at > http://maatkit.sourceforge.net/. > > Also, you might look into using an LVM snapshot to run the copy from. > That way it doesn't interfere with your operations as much. I do that > for some of our production slave servers myself. > > Keith > > Dan Buettner wrote: > > 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 Nov 27, 2007 4:35 PM, David Campbell <[EMAIL PROTECTED]> wrote: > > > > > >> 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://lists.mysql.com/mysql > >> To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >> > >> > >> > > > > > > > -- > Keith Murphy > > > editor: MySQL Magazine > http://www.mysqlzine.net > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Grant Limberg [EMAIL PROTECTED]