How to dump or export all the table definitions in a MySQL database
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!
mysqldump -u USERNAME –password=PASSWORD –no-data –opt DB1 > DUMPFILE
That’s it! Easy as a pie The key here is the –no-data option. It dumps all the table [...]
