Hello, I have two machines that I am trying to use replication on. Here are their configurations: master (my.cnf) log-bin serveri-d = 1
slave: server-id = 2 master-host=master.domain.com master-user=replicate master-password=replicatedb log-bin I followed the steps in the manual but found this error on my slave logs: 020820 13:24:52 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020820 13:24:52 Error updating slave list: 020820 13:24:52 Slave I/O thread exiting, read up to log 'FIRST', position 4 What does this mean? Whenever I make changes to the master, the Position changes: mysql> show master status; +----------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +----------------+----------+--------------+------------------+ | master-bin.002 | 208 | | | +----------------+----------+--------------+------------------+ but doesn't reflect on the slave: mysql> show master status; +----------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +----------------+----------+--------------+------------------+ | slave-bin.002 | 79 | | | +----------------+----------+--------------+------------------+ Should the "file"s be the same for both master and slave? Here are other things that might help: (slave) mysql> show processlist; | 2 | system user | none | NULL | Connect | 1945 | Slave: waiting for binlog update | NULL | mysql> show slave status; | master.domain.com | replicate | 3306 | 60 | | 4 | slave-relay-bin.002 | 4 | | No | Yes | | | 0 | | 0 | 0 | 4 | Any tips/advice? TIA! Froilan --------------------------------------------------------------------- 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
