On Tuesday 20 August 2002 09:02 pm, Froilan Mendoza wrote: > 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. Hmmm... When you set up the master database, did you copy all the *.frm, *.MYD, *.MYI to the slave database?
I also noticed in your email the my.cnf file on the master had "serveri-d" instead of "server-id" Try removing bin-log from the my.cnf on the slave. If I remember correctly, there is a way to set up the slave to keep "archives" of the updates. The master.info file on the slave should look something like this Ignor stuff in quotes, I added that. walt-bin.950 "log file on the master" 73 "position of the log file on the master" walt.nea-fast.com "master server name" repl "replication user name" passwd "replication password" 3306 "port" 60 6 60 Let me know if any of this helps! -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia 1-800-782-5150 ext. 1608 "If it's not broke....tweak it" --------------------------------------------------------------------- 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
