[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: InnoDB Backups
From:       "Heikki Tuuri" <Heikki.Tuuri () innodb ! com>
Date:       2004-01-31 21:42:40
Message-ID: 00ee01c3e843$26ac3a20$2d2bde50 () koticompaq
[Download RAW message or body]

Mauro,

----- Original Message ----- 
From: "Mauro Marcellino" <mmarcellino@palm.net>
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" <Heikki.Tuuri@innodb.com>
> To: <mysql@lists.mysql.com>
> Sent: Friday, January 30, 2004 4:22 AM
> Subject: Re: InnoDB Backups
>
>
> > Mauro,
> >
> > ----- Original Message ----- 
> > From: "Mauro Marcellino" <mmarcellino@palm.net>
> > 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/mysql?unsub=mmarcellino@palm.net
> >
> >
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=myodbc@freebsd.csie.nctu.edu.tw
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]