Thanks to Donna for that very useful SQL statement. Below is the script
I ended up writing to clean the eight-bajillion eventum_* tables that
accidentally got splattered into our servers.
Anyways, this is probably very useful for other types of bulk SQL stuff
via some BASH scripting so I figured
Daevid Vincent dae...@daevid.com wrote on 01/15/2009 09:57:19 PM:
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.
I think you may be over-panicing. :-)
If you do a DROP on the master and that replicates through, just like the
create did, then you're all set.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
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
Well surely its a simple case of drop the tables on the master and let
replication do the rest!
John Daisley
Email: john.dais...@butterflysystems.co.uk
Mobile: 07812 451238
MySQL Certified Database Administrator (CMDBA)
MySQL Certified Developer (CMDEV)
MySQL Certified Associate (CMA)
Comptia
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 +, John Daisley wrote:
Well surely
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
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
On Thu, Jan 15, 2009 at 20:44, 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:
On Thu, Jan 15, 2009 at 9:57 PM, 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
10 matches
Mail list logo