473,387 Members | 1,592 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 1079

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: jaykchan | last post by:
One of the table that is in a merge replication somehow is missing an index. Strangely, only the table in one of the subscriber of the merge replication is missing the index; another subscriber and...
4
by: SQLNow | last post by:
If I have two tables that I want to synchronize via replication publish subscriber model and they don't contain primary keys i.e. an ID field, but there are three columns that make a unique key. ...
1
by: Alex | last post by:
Hi, I just went through the install notes on erserver1.2 and saw a mention in there that every table for replication requires a integer based column. It also states that a new column is added for...
1
by: Trent | last post by:
Hello,everyone. I'm setting a db2 replication environment using UDB version 8.1.5 running on Windows 2000 servers. The source server is on a Windows server with the capture program running while...
6
by: RdR | last post by:
Hi, Has anyone encountered infinite looping in Q Replication? This happens when I have a source DB2 table A going to a target DB2 table B, it also happens that the samne target table B is...
8
by: Bri | last post by:
Greetings, After making various edits and deletes on aproximately 40,000 records in one table (on the Design Master) syncronization fails with Error 3052 - File Sharing Lock Count Exceeded....
2
by: adb | last post by:
I came up with a replication configuration that is basically the result of all the restrictions of replication as well as the restrictions of allowable software on work PC's and I was curious if...
8
by: sat | last post by:
Hi All! I have a small doubt in replication.Previously i was working on replication with the databases under the same instance.So it worked fine. Now i'm facing a new problem which is like, now...
11
by: Anthony Paul | last post by:
Hello everyone, I am involved in a scenario where there is a huge (SQL Server 2005) production database containing tables that are updated multiple times per second. End-user reports need to be...
2
by: zgb | last post by:
Hi, I'm using MS SQL server 2005. I have two identical databases - with one exception: they have different names (etc database1 and databse2), but their structure is completely same. Is it...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.