From: Adam Goldstein (whitewlfwhitewlf.net)
Date: Fri Jan 30 2004 - 15:15:59 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

The Hot backup/dump tools use the mysql server to create a live backup
while the server is running. On MyIsam tables, I think they are locked
during the entire process.. innodb may be different.

You can backup the DB files directly, but, the mysql server MUST be
shut down to do so.. which is likely not what you want. Since lots of
information may be sitting in the buffers when you copy the files,
along with file-close checks and such, you would only get partial data
backups, which would be far less effective to restore from. When the
mysql server is shut down, those buffers would all be sent to disk. Any
remaining FS/OS buffers would be honored by the FS call for copy. So,
yes it works fine if the files are copied when the server is off.

I am about to switch to innodb myself, and I am simply going to have to
buy the Innodb hot backup tool to make full backups. however, do not
forget that even those are out of date the moment the backup is done ;)
  Replication is your best friend, next to your Dog of course,

--
Adam Goldstein
White Wolf Networks
http://whitewlf.net

On Jan 30, 2004, at 11:50 AM, Mauro Marcellino wrote:

> 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.
>
> What do you mean by inconsistent? What does InnoDB Hot backup do
> differently than an open file agent?
>
> So the only two ways to do an online backup of InnoDB tables is InnoDB
> Hot
> backup or mysqldump?
>
>
> Thanks,
>
> Mauro
> ----- Original Message -----
> From: "Heikki Tuuri" <Heikki.Tuuriinnodb.com>
> To: <mysqllists.mysql.com>
> Sent: Friday, January 30, 2004 4:22 AM
> Subject: Re: InnoDB Backups
>
>
>> Mauro,
>>
>> ----- Original Message -----
>> From: "Mauro Marcellino" <mmarcellinopalm.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=mmarcellinopalm.net
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=whitewlfwhitewlf.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]