Walt, At 01:09 PM 8/20/2002 -0400, walt wrote: >on the slave you should run >show slave status
on slave: mysql> show slave status; +-----------------+-------------+-------------+---------------+-----------------+---------------------+----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-----------------+-------------+-------------+---------------+-----------------+---------------------+----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ | master.idsk.com | replicate | 3306 | 60 | | 4 | slave-relay-bin.001 | 4 | | No | Yes | | | 0 | | 0 | 0 | 4 | +-----------------+-------------+-------------+---------------+-----------------+---------------------+----------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ 1 row in set (0.00 sec) What in particular should I be looking at here? I can see Slave_SQL_Running: Yes. When i insert info into one of the master's table, slave's show master status is: +----------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +----------------+----------+--------------+------------------+ | slave-bin.001 | 79 | | | +----------------+----------+--------------+------------------+ master's show master status is: +----------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +----------------+----------+--------------+------------------+ | master-bin.002 | 162 | | | +----------------+----------+--------------+------------------+ I re installed everything and still got the same error: 020820 18:05:20 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4 020820 18:05:20 Error updating slave list: 020820 18:05:20 Slave I/O thread exiting, read up to log 'FIRST', position 4 >also on the slave check >/path/to/mysql/master.info >this file gives you good info and I had to change it manually when I changed >master server names in the my.cnf file my slave's master.info looks like: 4 master.idsk.com replicate replicatedb 3306 60 138206092 Anything wrong with it? >also, add >set-variable = slave_net_timeout=3600 >set-variable = net_read_timeout=3600 I have added this one, thanks. --------------------------------------------------------------------- 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
