Thanks Heikki, I knew about the binlogs but that "segment" word confused me. Now if I may "pester" you with 2 more questions... :-)
Quoting... "From the binlog segment you see if any of the .frm files changed between the moment you took a .frm files backup and the moment ibbackup finished its work." 1) Do you mean to say that you can actually look into the binlogs to determine what .frm's changed? (If so how?) Or do you mean that backing up the post ibbackup binlogs provides a snapshot containing changes that have occurred since ibbackup began? 2) Why backup the .frm's and binlogs before and after ibbackup? Why not just run ibbackup, backup the .frm's, do a mysqladmin flush-logs, backup the prior (non-current) binlogs then purge them? Thanks again for your answers and your patience, Steve Orr -----Original Message----- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 2:56 PM To: [EMAIL PROTECTED] Subject: Re: MySQL/InnoDB Hot Backups - What's a "binlog segment?" Steve, the binlog is the MySQL logical log which it writes if you specify [mysqld] log-bin in my.cnf. They are the files called 'hostname'-bin.00x in the datadir of MySQL. They contain all INSERT, UPDATE, etc. SQL statements in an almost human-readable form. The binlog is used to recover from a backup. Normally you should always archive the binlog files if you have important data. The 'binlog segment' means the binlog file(s) generated when the backup was running. Regards, Heikki ----- Original Message ----- From: ""Orr, Steve"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, June 12, 2002 8:20 PM Subject: MySQL/InnoDB Hot Backups - What's a "binlog segment?" > I'm confused about the meaning of the help text from ibbackup --help. > > Here's the text: > "You should make backups of the .frm files... both BEFORE and AFTER ibbackup > finishes its work, and also store the MySQL binlog segment which is > generated between the moment you copy the .frm files to a backup and the > moment ibbackup finishes its work... From the binlog segment you see if any > of the .frm files changed between the moment you took a .frm files backup > and the moment ibbackup finished its work." > > So what exactly is the "binlog segment?" Is it some mysterious file or > merely the text sections from the ibbackup output that refer to the lsn's? > > Here's some sample output: > " . . . > ibbackup: Found checkpoint at lsn 0 1418349381 > ibbackup: Starting log scan from lsn 0 1418349056 > . . . > ibbackup: A copied database page was modified at 0 1418349381 > ibbackup: Scanned log up to lsn 0 1418349381 > ibbackup: Full backup completed!" > > > Clueless in Montana, > Steve Orr > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
