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]

Reply via email to