>Description: I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a "load table from master" but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010410 16:37:24 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) and in the master log: 010410 16:35:58 3006 Connect [EMAIL PROTECTED] on 3007 Connect [EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum >How-To-Repeat: see below >Fix: This problem occurs when the my.cnf file on the master contains "log-bin=/var/log/replication.log" but just "log-bin" seems to work. However, how do you control the location and name of the log? (This may just be a documentation issue, but the error message is not very intuitive.) >Submitter-Id: <submitter ID> >Originator: Jim Ziegler >Organization: [EMAIL PROTECTED] (Jim Ziegler) > >MySQL support: [none | licence | email support | extended email support ] >Synopsis: replication-bad magic number-fire your magician >Severity: critical >Priority: >Category: mysql >Class: >Release: mysql-3.23.36 (Source distribution) >Environment: System: Linux jimz 2.2.19 #1 Sun Jun 24 15:06:27 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 14 Mar 28 11:57 /lib/libc.so.5 -> libc.so.5.4.46 -rw-r--r-- 1 root root 589460 Mar 19 08:47 /lib/libc.so.5.4.46 lrwxrwxrwx 1 root root 13 Jun 11 13:04 /lib/libc.so.6 -> libc-2.2.3.so -rwxr-xr-x 1 root root 1104456 May 28 18:49 /lib/libc-2.2.3.so -rw-r--r-- 1 root root 2522408 May 28 18:51 /usr/lib/libc.a -rw-r--r-- 1 root root 178 May 28 18:51 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Nov 15 2000 /usr/lib/libc-client.a -> c-client.a lrwxrwxrwx 1 root root 18 Nov 15 2000 /usr/lib/libc-client.so -> libc-client.so.4.7 -rw-r--r-- 1 root root 665260 Sep 1 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all --------------------------------------------------------------------- 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