One thing I left out is that we are running 4.1.8-Max-log not 4.1.8-standard-log
Could that have anything to do with it? Thanks for any insight, Frank On Mon, 17 Jan 2005 15:55:06 -0500, Frank Febbraro <[EMAIL PROTECTED]> wrote: > Hey all, > > I have setup replication in the past on 4.0.x servers so I figured I > knew what I was doing...silly me. I reread all of the docs and best I > can tell I followed them sufficiently. > > When I start my slave, the SQL Thread starts, but the I/O thread never > starts, and thus the Master Thread never starts. There are no error > messages in any logs, or the show slave status screen. Below are my > relevant configurations. I am very sorry if I have left anything > significant out. > > Thank you for any help, > Frank > > MASTER CONFIG > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > [EMAIL PROTECTED] cat /etc/my.cnf > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > server-id=100 > log-bin > binlog-do-db=internal > binlog-ignore-db=mysql > > [mysql.server] > user=mysql > basedir=/var/lib > > [safe_mysqld] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > mysql> show master status\G > *************************** 1. row *************************** > File: server2-bin.000004 > Position: 874 > Binlog_Do_DB: internal > Binlog_Ignore_DB: mysql > 1 row in set (0.00 sec) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > SLAVE CONFIG > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > [EMAIL PROTECTED] cat /etc/my.cnf > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > server-id=200 > replicate-do-db=internal > > [mysql.server] > user=mysql > basedir=/var/lib > > [safe_mysqld] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > [EMAIL PROTECTED] cat /var/lib/mysql/master.info > 14 > server2-bin.000003 > 79 > cms.internal.org > slave > slavepass > 3306 > 60 > 0 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > mysql> show slave status \G > *************************** 1. row *************************** > Slave_IO_State: > Master_Host: cms.internal.org > Master_User: slave > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: server2-bin.000003 > Read_Master_Log_Pos: 79 > Relay_Log_File: server1-relay-bin.000001 > Relay_Log_Pos: 4 > Relay_Master_Log_File: server2-bin.000003 > Slave_IO_Running: No > Slave_SQL_Running: Yes > Replicate_Do_DB: internal > Replicate_Ignore_DB: > Replicate_Do_Table: > Replicate_Ignore_Table: > Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 0 > Last_Error: > Skip_Counter: 0 > Exec_Master_Log_Pos: 79 > Relay_Log_Space: 4 > Until_Condition: None > Until_Log_File: > Until_Log_Pos: 0 > Master_SSL_Allowed: No > Master_SSL_CA_File: > Master_SSL_CA_Path: > Master_SSL_Cert: > Master_SSL_Cipher: > Master_SSL_Key: > Seconds_Behind_Master: NULL > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
