Re: Mysql Online Backup.

2003-08-27 Thread Heikki Tuuri
lt;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 7:47 PM Subject: Re: Mysql Online Backup. 2003年 8月 28日 木曜日 01:43、Nils Valentin さんは書きました: > Hi Chris, > > 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました: > > A very good question! One which I will atte

RE: Mysql Online Backup.

2003-08-27 Thread Jon Frisby
> > The advantage of other methods is that you avoid all sorts of nasty > > locking on various parts of your database. The advantage of > the Hot Copy > > product that Innobase Oy sell is that it doesn't place any > locks on your > > InnoDB table space when it runs. > > Wouldn't that break the A

Re: Mysql Online Backup.

2003-08-27 Thread Nils Valentin
2003年 8月 28日 木曜日 01:43、Nils Valentin さんは書きました: > Hi Chris, > > 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました: > > A very good question! One which I will attempt to provide a half-decent > > answer for. > > > > Trying to execute a transaction that involves grabbing massive amounts of > > data from var

Re: Mysql Online Backup.

2003-08-27 Thread Nils Valentin
Hi Chris, 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました: > A very good question! One which I will attempt to provide a half-decent > answer for. > > Trying to execute a transaction that involves grabbing massive amounts of > data from various tables while still allowing updates to be committed can >

Re: Mysql Online Backup.

2003-08-27 Thread Nils Valentin
Hi Chris, 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました: > A very good question! One which I will attempt to provide a half-decent > answer for. > > Trying to execute a transaction that involves grabbing massive amounts of > data from various tables while still allowing updates to be committed can

Re: Mysql Online Backup.

2003-08-27 Thread Nils Valentin
Hi All, my $0.0.2... anybody correct me please if you know it better...;-) 2003年 8月 27日 水曜日 23:22、P Srinivasulu さんは書きました: > If the backup solutions are there already, why is that a future > requirement for Mysql? > > Thanks, > Srinivasulu. > > >>> Chris Nolan <[EMAIL PROTECTED]> 8/27/2003 6:41:2

Re: Mysql Online Backup.

2003-08-27 Thread Chris Nolan
A very good question! One which I will attempt to provide a half-decent answer for. Trying to execute a transaction that involves grabbing massive amounts of data from various tables while still allowing updates to be committed can be tricky. At best, this means performance problems. Please don't

Re: Mysql Online Backup.

2003-08-27 Thread P Srinivasulu
If the backup solutions are there already, why is that a future requirement for Mysql? Thanks, Srinivasulu. >>> Chris Nolan <[EMAIL PROTECTED]> 8/27/2003 6:41:27 PM >>> Hi! You can currently do this with InnoDB with mysqldump (look at the --single-transaction switch). I use it for backing up

Re: Mysql Online Backup.

2003-08-27 Thread Chris Nolan
Hi! You can currently do this with InnoDB with mysqldump (look at the --single-transaction switch). I use it for backing up a 12 GB mail database without problems. Regards, Chris P.S. Keep up the great work over there at Novell! Tell us where to send the expensive bottles of alcohol for when

Mysql Online Backup.

2003-08-27 Thread P Srinivasulu
Hi All, The link below says that online backup functionality will be provided in Mysql-5.1. I think its already there in the form of mysqlhotcopy. Is Mysql going to extend the functionality of mysqlhotcopy so that it works for Innodb tables also? or they are going to provide independent online bac