I have a side project I'd like to write.... A small utilitl that will traverse my database automatically and spit out every table, row, and column in a really readable format. (I'll probably use yaml). Phpmyadmin does something similar, except you have to use the browser....I want this to run daily without the browser.
I guess you could also look at it as my own mysqldump. Except mysqldump only has an xml option, no yaml or anything that I consider easily readable.
I'd of course like to rely on sqlobject as much as possible for this endeavor.
My first silly question is how can I, using sqlobject, find the names of all the tables in my database.
(A related question...can I find the names of all the databases as well?)