Taking and Deploying the Dump (fast)

Taking a Dump from command line-
mysqldump -h localhost -u root -p emba > c:\dbname.sql

Deploying the Schema from command line-
mysql -u root -p emba < dbname.sql

advantage- far much faster in comparison to doing it other wise
just make sure that you have created a database before deploying your .sql file into database.