ahh.......... http://www.mysql.com/doc/en/Replication_Options.html: replicate-wild-ignore-table=db_name.table_name
tks alec -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 14:29 To: Tom Roos Subject: Re: question: replication of tmp table..... Hello, Tom I have had this probelm too. I don't know if it is supposed to work, but I solved it by setting MySQL not to replicate tables called temp%. There is no point in replicating temp tables anyway because they could not be accessed on another machine. There would, I suppose, be a problem if I did INSERT ... SELECT FROM temptable. ----------------------- i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now and then i get a error on the slave. the error is that it cannot insert data into a table that does not exist. the problem is that the table its complaining about is a tmp table. that table is created when (a) user(s) runs a query. in the query, i first create a tmp table, insert data from another table, run a join with another table and display the result. the query is executed from a web page so all is done with a php script. to get around the problem, i then create the table on the slave. does 4.0.13 replication handle tmp tables ok? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
