I'm using the script at the bottom of this page:
http://dev.mysql.com/doc/refman/5.0/en/c heck-table.html
Do any of you bash gurus know how to get it to where I can put in a list of tables not to check? Some of the tables are archive tables and I don't need to know on an immediate basis if those tables are broken after a server crash.
UPDATE: I've moved the script to pastebin so that people can comment on it more easily:
http://pastebin.ca/995893
I tried putting in a section myself to exclude tables but it was EPIC FAIL.
Help me, Obi Wan Livejournal! You're my only hope.
UPDATE:
drunkencritch gave me a hand with it and it's working now. It was pretty easy but I didn't know how to approach it... he removed the tables with a grep -v command in line 88. Woo!
http://dev.mysql.com/doc/refman/5.0/en/c
Do any of you bash gurus know how to get it to where I can put in a list of tables not to check? Some of the tables are archive tables and I don't need to know on an immediate basis if those tables are broken after a server crash.
UPDATE: I've moved the script to pastebin so that people can comment on it more easily:
http://pastebin.ca/995893
I tried putting in a section myself to exclude tables but it was EPIC FAIL.
Help me, Obi Wan Livejournal! You're my only hope.
UPDATE:


Comments
DBEXCLUDE="TABLE1 TABLE2 TABLE3"