How to take MySQL database dumps in Terminal.

Use the following command to do MySQL dump of your database:
 mysqldump -h <hostname> -u <database user name> -p<Database Password> <database name> > <path><filename.sql>

How to restore MySQL dump into our current Database:
mysql -h <hostname> -u<database  user name> -p<Database password> <Database Name> < <path/filename.sql>

How to take backup of only the table structure of MySQL Database:
 mysqldump -h <hostname> -u <database user name> -p<Database Password> <database name> --no-data > <path><filename.sql>

How to take backup of selected MySQL tables: mysqldump -h <hostname> -u <database user name> -p<Database Password> <database name> <tablename1> <tablename2> ..... <tablenameN>  > <path><filename.sql>