Hi, I have a mysql 4.0.21 master and a 4.0.18 slave.
I am trying to maintain a replication of a DB named masterdb. My goal is to have multiple slaves with a copy of masterdb. On the master I specified in my.cnf binlog-do-db=masterdb. On the slave I specified replicate-do-db=masterdb in my.cnf. I took a snap shot of masterdb as per the user documentation. I loaded this on the slave server and set up the slave to point to the master using the changer master to ... following the proper syntax. The slave halts with the following messages in the .err file: 041006 12:06:06 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'aaa-bin.008' at position 79 ERROR: 1146 Table 'reporting.linkdata' doesn't exist 041006 12:06:37 Slave: Error 'Table 'reporting.linkdata' doesn't exist' on query 'replace into linkfilters (ip,sstatus,cstatus,dusers) select ip, sum(spam), sum(total), sum(dusers) from reporting.linkdata as a left join reporting.users as u on u.eid=a.eid where unix_timestamp(u.lastupdate) >= 0 group by ip having sum(a.total)>=15 and sum(a.dusers)>=6'. Default database: 'masterdb', Error_code: 1146 041006 12:06:37 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'aaa-bin.007' position 73927 On the master server there is a database named reporting that does not exist on the slave and should not exist because it is used by the master server only. >From my reading of the MySQL documentation on the binary log files works, (correct me if I am wrong. PLEASE!) the master binary log file records all transactions needed to rebuild the database(s) in the event of a catastrophe. In the context of replication, (from a high level view) the slave server reaches into the master and executes transactions to update itself (something like 'mysqlbinlog aaa-bin.007 |mysql -u rep -h slave'), correct? If this assumption about replication is correct then the query: 'replace into linkfilters (ip,sstatus,cstatus,dusers) select ip, sum(spam), sum(total), sum(dusers) from reporting.linkdata as a left join reporting.users as u on u.eid=a.eid where unix_timestamp(u.lastupdate) >= 0 group by ip having sum(a.total)>=15 and sum(a.dusers)>=6' holds the key to my problem because reporting.linkdata and reporting.users do not exist on the slave since it has no concept of the database named reporting. Is there a way to rework this query so that either there are no references to the reporting database or to configure my.cnf on the master and slave to handle this query? Thanks in advance, -Bill Thomason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
