Hi, On 13 Feb 2002, at 12:44, Henning Sprang wrote: > Was something wrong with this post or is it really such a weird > problem that there is neither a solution nor anything i could do to > solve it, nor anything i could do to find out more about it? Well. Replication is somewhat weird. ;-)
> Slave: error running query 'drop table tropon_base.TB_Tage,tropon_0000001.TB_Tage' >020209 3:49:32 Error > running query, slave aborted. Fix the problem, and re-start the slave > thread with "mysqladmin start-slave". > ERROR: 1051 Unknown table 'TB_Tage,TB_Tage' Sounds, as if you were doing some cross database updates / inserts. This might lead to problems if you only replicate some of the databases on the master. So, if there is a Database A, B, C, D on master each with tables A1,A2,A3 or B1,B2,B3 and so on, and you only replicate A and B and you do: use A; insert into C.C1 (a,b,c) VALUES (1,2,3); you'll get this error. You might avoid it with replicate-wild-ignore-table=C.* More details in: http://www.mysql.com/documentation/mysql/bychapter/manual_My SQL_Database_Administration.html#Replication_Options But note that: use C; insert into A.A1 (a,b,c) VALUES (1,2,3); would not be replicated to the slave, if you choosed to replicate only A and B. Even though it affects A. (Strange, but that's the way live goes). At least with MySQL 3.23.36 So best is to avoid cross-databases actions except for SELECT with replication enabled. Bye Tobias ------------------------------- Tobias Eggendorfer E-Mail: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
