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 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. 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 ? If yes, is there a command line option to inquire this info ? Best regards Nils Valentin Tokyo/Japan > > > -- > 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
