List:General Discussion« Previous MessageNext Message »
From:Steve Orr Date:June 13 2002 12:27am
Subject:RE: MySQL/InnoDB Hot Backups - What's a "binlog segment?"
View as plain text  
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:Heikki.Tuuri@stripped]
Sent: Wednesday, June 12, 2002 2:56 PM
To: mysql@stripped
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"" <sorr@stripped>
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 <mysql-thread111749@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-mysql=freebsd.csie.nctu.edu.tw@stripped>
> 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 <mysql-thread111782@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-sorr=rightnow.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
MySQL/InnoDB Hot Backups - What's a "binlog segment?"Steve Orr12 Jun
Re: MySQL/InnoDB Hot Backups - What's a "binlog segment?"Heikki Tuuri12 Jun
RE: MySQL/InnoDB Hot Backups - What's a "binlog segment?"Steve Orr13 Jun
  • Re: MySQL/InnoDB Hot Backups - What's a "binlog segment?"Heikki Tuuri13 Jun