Help.. Replication is not working.. not sure why..
ON MASTER: /etc/my.cnf [mysqld] datadir=/db/mysql socket=/var/lib/mysql/mysql.sock skip-innodb log-bin=mylog server-id=1 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid notice this...????? mysql> SHOW MASTER LOGS\g ERROR: binlog is not open ON SLAVE: /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #log=/var/log/mysql_query.log skip-innodb server-id=3 log-bin=mylog #master-host=172.16.100.133 #master-user=sa #master-password=xxxxxx #master-port=3306 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid /var/log/mysqld.log 020815 23:13:11 mysqld started /usr/libexec/mysqld: ready for connections 020815 23:13:11 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020815 23:13:11 Error reading packet from server: Binary log is not open (read_er rno 0,server_errno=2000) 020815 23:13:11 Slave: Failed reading log event, reconnecting to retry, log 'FIRS T' position 4 Help... tell me what I did wrong! John Gruber --------------------------------------------------------------------- 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
