So you have a database with loads of tables. You want the table definitions of all of them. You don't really need the data. mysqldump to the rescue!
[sourcecode]mysqldump -u USERNAME --password=PASSWORD --no-data --opt DB1 > DUMPFILE[/sourcecode]
That's it! Easy as a pie :) The key here is the …