Use the –no-data switch with mysqldump to tell it not to dump the data, only the table structure.
This will output the CREATE TABLE statement for the tables.
Something like this
mysqldump –no-data -h localhost -u root -ppassword mydatabase > mydatabase_backup.sql
To target specific tables, enter them after the database name.
mysqldump –no-data -h localhost -u root -ppassword mydatabase table1 table2 > mydatabase_backup.sql
