g'day listers
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?
_________ _______ _ __
/___ ___/ / ___ / / \ / /
/ / / / / / / ^ v /
/ / / /__/ / / / \/ / /
/_ / /______ / /_ / /_ /
Cell: 083 440 2213
Ph: 021 980 4969
