The mysql dump utility can be used as like taking the mysql database

Syantax will be

mysqldump -d -h localhost -u root -p 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 -p sampledatabase  > dumpfile.sql