Dump just the table structure to a file in MySQL

For this exercise, we will use the mysqldump utility the same as if we were backing up the entire database.

September 11, 2006 · 1 min · 11 words · Susan Stephens

Example:

mysqldump -d -h localhost -u root -p2Uad7as9 database01 > dumpfile.sql