469,082 Members | 1,235 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

question: replication of tmp table.....

------_=_NextPart_001_01C349FB.3DE177A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.=20

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
------_=_NextPart_001_01C349FB.3DE177A0--
Jul 19 '05 #1
0 1025

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by SQLNow | last post: by
1 post views Thread by Alex | last post: by
8 posts views Thread by sat | last post: by
2 posts views Thread by zgb | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.