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]
