The curse of the impatient and deadlined sysadmin: 060227 19:22:28 [ERROR] The slave I/O thread stops because master and slave have different values for the COLLATION_SERVER global variable. The values must be equal for replication to work
Change default charset, all works. Sorry for the noise. ;) Rob > -----Original Message----- > From: Rob Gormley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 28 February 2006 12:36 PM > To: mysql@lists.mysql.com > Subject: Elementary replication > > Hi, > > Not having a lot of luck with replication. > > Have 2 4.1x boxes > > Slave is configured, via my.cnf, to only replicate three tables: > > replicate-do-table = db.table1 > replicate-do-table = db.table2 > replicate-do-table = db.table3 > > SHOW SLAVE STATUS; (sanitised) output is as follows: > > mysql> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: > Master_Host: db0.xxx > Master_User: xxx > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: mysql-bin.001305 > Read_Master_Log_Pos: 10165261 > Relay_Log_File: db2-relay-bin.000002 > Relay_Log_Pos: 4 > Relay_Master_Log_File: mysql-bin.001305 > Slave_IO_Running: No > Slave_SQL_Running: Yes > Replicate_Do_DB: > Replicate_Ignore_DB: > Replicate_Do_Table: db.table1,db.table2,db.table3 > Replicate_Ignore_Table: > Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 0 > Last_Error: > Skip_Counter: 0 > Exec_Master_Log_Pos: 10165261 > 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 > 1 row in set (0.00 sec) > > > Master position was set with "CHANGE MASTER TO > MASTER_LOG_FILE='mysql-bin.001305', MASTER_LOG_POS = 10165261" > to deal with restoring a mysqldump, and using a running > server (I'd really like to avoid shutting down the master) > > Replication has never been run on this machine. > > Where can I go from here to get it running? > > Rob > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]