How to create mysql database baseline without data

Question

How to create a mysql database baseline without data in it so that we could just use the base line to create another instance??

Answer 1

Create a dump of the schema only:

mysqldump -d yourdatabase >dumpfile.sql

Import this dump into your new database:

mysql yournewdatabase <dumpfile.sql