you misunderstand me. I have three servers (dev, test, prod) that all have maybe 3 databases EACH that have all these eventum* tables in them. don't ask. a simple "trickle" won't do. I'm writing a script to loop through them all.
On Fri, 2009-01-16 at 01:57 +0000, John Daisley wrote: > Well surely its a simple case of drop the tables on the master and let > replication do the rest! > > > John Daisley > On Thu, 2009-01-15 at 17:44 -0800, Daevid Vincent wrote: > > > I've been tasked with cleaning up a bunch of 'eventum' tables that got > > accidentally dumped into several databases and then replicated. > > > > I'm wondering if I can just go through with a simple command to blow > > these all away: > > > > find /var/lib/mysql/ -name eventum* > > > > Or is there some other magic that a "DROP TABLE eventum*" does?