Hello, I have set up replication between several servers, all using the same version of mysql (4.0.25, however on different Versions of SuSE-Linux).
Production databases of the master server are replicated on the slave server using the same database name with an underscore. This works in all but one case. I'm connecting through a tunnel, so that's the reason for Master_Host/Master_Port, and I have defined a user "replikation" that has the necessary privileges (identical on all servers). "show slave status" gives: | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +-------------+-------------+-------------+---------------+-----------------+---------------------+------------------------+---------------+-----------------------+------------------+-------------------+-----------------+---------------------+------------+------------+--------------+---------------------+-----------------+ | 127.0.0.1 | replikation | 13306 | 60 | master-host-bin.7397 | 261948 | slave-host-relay-bin.001 | 2463878 | master-host-bin.7397 | Yes | Yes | _rtest | | 0 | | 0 | 261948 | 2463878 | So it seems everything is ok. But changes in the original database "rtest" on the masterserver aren't replicated to "_rtest" on the slave. I tried different slaves, but to no avail. Any ideas how to track down this error? Greetings Neven -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
