Brian Keck <[EMAIL PROTECTED]> wrote: > > 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.
What is your current db? Option 'replicate-do-db' means that only commands where current database 'myradius' will be replicated. > > 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) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]