Hi, we're running 4.1.11 on two Debian woody machines and replication on the 'laterooms' database is working marvellously with the exception of altering table structure. If I execute an ALTER TABLE ... ADD... no error is generated, but the slave does not add the column.
Of course then INSERTS to the table fail due to the missing column and likewise ALTER TABLE.... DROP fails because the column doesn't exist on the slave :) The permissions for the 'repl' user on the master are all "N" except for Repl_slave_priv. (I even tried adding Alter_priv for the repl user but it made no difference) MASTER server-id = 1 binlog-do-db = laterooms mysql> show master status; +------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+----------+--------------+------------------+ | mysql-bin.000047 | 21195154 | laterooms | | +------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) SLAVE server-id = 2 binlog-do-db = laterooms mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: meg Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000047 Read_Master_Log_Pos: 21183485 Relay_Log_File: liz-relay-bin.000005 Relay_Log_Pos: 76813 Relay_Master_Log_File: mysql-bin.000047 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: 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: 21183485 Relay_Log_Space: 76813 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: 0 1 row in set (0.00 sec) Any ideas would be warmly welcomed! Cheers, Gavin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]