I don't know of any way of doing this for all tables. I wrote a python script that creates a html file with information about tables (engine, fields,keys,indices)
If you are interested in it I can email it Olaf On 7/23/07 11:34 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi; > I need to see the table structure of all the tables of a database I have. I > could also just dump all the data from all the tables in the database and copy > the database, thus grabbing the table structures. I can“t find in the > documentation how to do either of those. Please advise. > TIA, > Tony > ________________________________________________________________________ > AOL now offers free email to everyone. Find out more about what's free from > AOL at AOL.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]