hello, i have major problem with setting up replication.
both ends are running mysql 3.23.49 i have set up proper entries in my.cnf on both sides and have replicated the dbs. now, on master: show master status reads: +--------------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--------------------+----------+--------------+------------------+ | bdnotebook-bin.001 | 758 | | | +--------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) show processlist reads: | 4 | root | linux.compfort | NULL | Binlog Dump | 1212 | Slave connection: wa iting for binlog update | NULL | now on slave: show slave status reads: | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-------------+-------------+-------------+---------------+----------+ -----+---------------+-----------------+---------------------+-------- ----+------------+--------------+ | 10.0.0.111 | rep | 3306 | 30 | | 35 | Yes | | | 0 | | 0 | +-------------+-------------+-------------+---------------+----------+ -----+---------------+-----------------+---------------------+-------- ----+------------+--------------+ show processlist: | 1 | system user | none | NULL | Connect | 294 | Waiting to reconnect after a failed read | NULL | in slave's logfiles i see these errors: 020531 14:04:08 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 35 020531 14:04:08 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 35 020531 14:04:08 Slave: received 0 length packet from server, apparent master shutdown: (0) and the databases are not being updated. what am doing possibly wrong ? have i missed something ? please help :> terry --------------------------------------------------------------------- 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
