Mauro, ----- Original Message ----- From: "Mauro Marcellino" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, January 30, 2004 6:51 PM Subject: Re: InnoDB Backups
> By open file tool I mean software that works concurrently with a backup > suite such as veritas that would backup any open files (such as MySQL > binaries) that would normally be skipped. with Google I found something called an 'open file tool'. I do not know if it works properly with InnoDB or other relational databases. Best to test it very carefully. > What do you mean by inconsistent? What does InnoDB Hot backup do > differently than an open file agent? It checks the consistency of each InnoDB data page and archives the log as well. And it has been extensively tested. > So the only two ways to do an online backup of InnoDB tables is InnoDB Hot > backup or mysqldump? Also snapshot file systems, like the Veritas file system should work, though I have not tested them. > Thanks, > > Mauro Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ > ----- Original Message ----- > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, January 30, 2004 4:22 AM > Subject: Re: InnoDB Backups > > > > Mauro, > > > > ----- Original Message ----- > > From: "Mauro Marcellino" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.myodbc > > Sent: Thursday, January 29, 2004 10:44 PM > > Subject: InnoDB Backups > > > > > > > ------=_NextPart_000_00CE_01C3E67E.9D867B90 > > > Content-Type: text/plain; > > > charset="iso-8859-1" > > > Content-Transfer-Encoding: quoted-printable > > > > > > I have made a couple of other postings related to this but I guess my > > > question is: > > > > > > Can I backup InnoDB tables (binary files) using an open file agent? > > > > what do you mean by an open file agent? > > > > You cannot just copy the ibdata files and ib_logfiles as is, because they > > would be inconsistent. A commercial tool to make an online (= hot) binary > > backup is InnoDB Hot Backup. A free way to make an online backup is to use > > mysqldump. > > > > > If yes...and I am using Automatic COMMITs my backup will be current? > > > > > > If I am not using Automatic COMMITs then my backup will contain data = > > > up > > > to the last COMMIT (In other words, data since the last COMMIT will not > > > be included in the backup. Is this true? > > > > > > I appreciate any guidance...Thanks Much! > > > > > > Mauro > > > > Best regards, > > > > Heikki Tuuri > > Innobase Oy > > http://www.innodb.com > > Foreign keys, transactions, and row level locking for MySQL > > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up > MyISAM > > tables > > > > Order MySQL technical support from https://order.mysql.com/ > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
