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
