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.
Syntax:
mysqldump -d -h localhost -u root -pmypassword databasename > dumpfile.sql
The only option that is different than creating an entire backup is the -d switch, which tells mysqldump not to output the data.
Example:
mysqldump -d -h localhost -u root -p2Uad7as9 database01 > dumpfile.sql
The Geek is the founder of How-To Geek and a geek enthusiast. This article was written on 09/11/06 and tagged with: MySQL
