Yeah, you're right. On Fri, Jan 16, 2009 at 10:57 AM, Daevid Vincent <dae...@daevid.com> wrote:
> 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? > > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
