I've been using mysqlbinlog to capture a file of inserts/updates/deletes on numerous servers since the early 3.23.x days. I have 3.23.46-max on a pair of servers now though where it is exhibiting some strange behavior. Based on some emailed suggestions I've tried leaving off the "-uroot -ppassword" parameters and also tried a binary from an older release of MySQL (3.23.39 which works fine on another server with .39 of MySQL running).
The server I'm testing on right now has system-bin.001 and system-bin.002 files where I stopped/started the server without a flush. The first file logged basically nothing and I see a "rotate to server-bin.002" line when I dump it so the files obviously have internal links to each other (which I didn't know previously). Anyway, the server is 3.23.46-max and I am using InnoDB tables on this server which I am NOT using on any of the other numerous servers which are acting more the way I think they should. Some details: .46 binlog binary without -uroot: Running it against the .001 log file shows the contents of that file only. Does not link to .002 but does give the # prompt back as soon as it finishes. .46 binlog binary with -uroot: Links to .002 and shows me everything logged from both files and hangs and never (waited 5+ minutes) gives back the # prompt. .39 binlog binary without -uroot: Same as .46 version above .39 binlog binary with -uroot: Same as .46 version above but errors and drops back to a # prompt perhaps 2 minutes later. Gives error "ERROR: Error reading packet from server:" At this point I will experiment with processing the .001, .002, .003 ... files individually in turn without providing the -uroot -ppassword parameters. --------------------------------------------------------------------- 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
