By the subject line, it would these are all MyISAM tables. If true, then deleting the files should do the trick. If any of them happens to be an InnoDB table, it won't work and you'll have to do some gyrations to get them dropped. It'll be a mess.
Since you're accessing all the databases any way why not just loop through all the servers with the command: mysql -u<userid> -p<password> -h<server> -e'drop table if exists <db>.eventum' ???? On Thu, Jan 15, 2009 at 7:44 PM, Daevid Vincent <dae...@daevid.com> 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? > > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
