"Nils Valentin" <[EMAIL PROTECTED]> wrote: > Hi Victoria, > > 2003? 8? 21? ??? 20:20?Victoria Reznichenko ????????: >> "Nils Valentin" <[EMAIL PROTECTED]> wrote: >> > 2003? 8? 21? ??? 16:09?Victoria Reznichenko ????????: >> >> "Nils Valentin" <[EMAIL PROTECTED]> wrote: >> >> > This time I am using 4.0.13-max (tar format from www.mysql.com) on >> >> > Redhat 9. >> >> > >> >> > When I issue the command mysqlbinlog it does not show me the whole >> >> > binary logfile but just the first line or so (below). >> >> > >> >> > mysqlbinlog baby-bumble-bee-bin.000009 >> >> > # at 4 >> >> > #030814 14:38:17 server id 1 Start: binlog v 4, server v created >> >> > 700101 9:00:00 >> >> > >> >> > I understood that I can use the tool to view the whole binary log >> >> > data. >> >> >> >> Yes. >> >> >> >> > Am I mistaken ? >> >> >> >> Probably your version of mysqlbinlog can't read binary logs 4.0.x MySQL >> >> server. >> > >> > Thank you for the reply. I just had a chance to double check on a Suse >> > Linux 8.1 with mysql 4.1-alpha (rpm format) and it works there. >> > >> > Hmmmm..... so must be a bug ?? >> >> Nils, what is the version of mysqlbinlog and what is the version of MySQL >> server, that produces binary logs? > > Thank you for asking the right questions ;-). > > the mysqlbinlog version 1.6 came with Mysql -4.0.13 (tar format from > www.mysql.com) - used on RH9
Hmm.. strange .. I have mysqlbinlog v2.6 in my 4.0.13 binary distribution. > the mysqlbinlog version 2.3 came with MySQL-4.1-alpha (rpm format from > www.mysql.com) - used on Suse 8.1 > > After a long follow up I reallized that I must have used the mysqlbinlog > version 1.6 on the file produced from the mysqbinlog version 2.3. mysqlbinlog v1.6 can read binary log files produced 3.23 MySQL server. > > However looking inside of the binary logfile itself I found this in the very > first line now: > > #030814 14:38:17 server id 1 log_pos 4 Start: binlog v 3, server v > 4.1.0-alpha-Max-log created 030814 14:38:17 > # at 79 > > > It is saying "...binlog v 3... " does that signify the binlog protocol version > ? It's a version of binary log format. > > If yes, is there a command line option to inquire this info ? > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]