Hello,
I'm having trouble with replication. The binary logs arrive in the
slave directory, but don't get inserted into the database.
I'm just a beginner at SQL & mysql, in case it isn't obvious from
the following.
The replication is limited to a database called mipradius by a slave config
'replicate-do-db=myradius', though the master sends updates for all databases.
There's nothing in the slave mysql.err after ...
031106 14:56:38 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication
started in log 'xswirz0101-bin.004' at position 7838142
The master (UltraSPARC called xswirz0101 aka hass) is running
mysql-standard-4.0.15-sun-solaris2.8-sparc.
The slave (PC called castor) is running 4.0.16 from the current debian unstable.
SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Master_Host: xswirz0101.iplab.trl.telstra.com.au
Master_User: repl
Master_Port: 3306
Connect_retry: 60
Master_Log_File: xswirz0101-bin.004
Read_Master_Log_Pos: 8612228
Relay_Log_File: castor-relay-bin.001
Relay_Log_Pos: 774135
Relay_Master_Log_File: xswirz0101-bin.004
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_do_db: myradius
Replicate_ignore_db:
Last_errno: 0
Last_error:
Skip_counter: 0
Exec_master_log_pos: 8612228
Relay_log_space: 774135
1 row in set (0.00 sec)
Thanks for any help,
Brian Keck
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
