List all tables containing a given column name

Question

How do a I list all tables containing a given column name? I'm using Mysql version 4.1.13-nt-log. I know versions less than 5 dont have an information_scheme DB.

Answer 1

try this:

mysqldump -u root -p –all-databases –single-transaction > all.sql

and then do the searching the old-school way in a text editor with find

---

also found this... looks promising, but I'm not sure how ambitious you are

http://mike.kruckenberg.com/presentations/Creating_INFORMATION_SCHEMA.pdf