"Tom Roos" <[EMAIL PROTECTED]> wrote: > > 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?
Replication with temporarytables should work well. Could you provide error message, failed query and replication options? -- 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]