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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 30, 2004 4:22 AM Subject: Re: InnoDB Backups
Mauro,MyISAM
----- 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 uptables
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]
