Hello, I suggest to you have the same version of mysql in both servers.
regards El Miércoles, 6 de Octubre de 2004 13:07, Bill Thomason escribió: > 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]
