The thing is that this particular table in database 'A' contains bounceback email addresses, all other databases are customer databases containing pretty large subscriber tables. Now I need to find matches between this bounceback table and all other customer subscriber tables. So I'd like to do a join over these, which is not possible because they reside in different databases (Like SELECT s.name FROM bouncebacks b, subcriber s where s.email = b.email). So if I could replicate this table, I could perform the above join. right now I find matches between the bounceback and the subscriber list by scripting, which is slooooooow - with ca. 10,000 bouncebacks and say up to 15,000 subscribers/customer.
I don't really like this concept, but I can't think of a better one... Thanks again for suggestions! Tom > -----Ursprüngliche Nachricht----- > Von: Paul DuBois [mailto:[EMAIL PROTECTED] > Gesendet: Freitag, 14. März 2003 19:19 > An: Brandl, Thomas; [EMAIL PROTECTED] > Betreff: Re: replication on single server > > > At 10:49 +0100 3/14/03, Brandl, Thomas wrote: > > > Hey everybody, > >> > >> I want to replicate several tables from one database to all other > >> databases on the same machine, so to say a table-level-replication > >> Simply said, imagine this scenario: > >> A MySQL server with about 10 databases: A and 1 to 9. > >> Database A contains a 'special' table that is supposed to be > >> replicated to all other databases on the same machine, so > it is kinda > >> like the master database. The table has the same name on every > >> database. > >> Is such a thing possible and if yes, how? > >> > >> Thanks very much for your help! > >> > > > Thomas > > I don't understand why you'd bother. Put it in one database and grant > everybody permission to access it. Wouldn't that accomplish the same > thing, without all the headache of trying to copy it everywhere? > > > -- > Paul DuBois, [EMAIL PROTECTED] > http://www.kitebird.com/ > sql, query > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
