Re: trouble replicating
On Wed, 12 Nov 2003 12:14:05 +0200, Victoria Reznichenko wrote: Yes, 'mipradius' is a current database and if you use option 'replicate-do-db= mipradius', 'insert into mipsessions ..' query should be replicated. But in the first post you said about database 'myradius', is this a typo? How embarrassing, It works now, Thanks, Brian Keck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
trouble replicating
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]
