Syntax:
mysqldump db_name tb_name1 tb_name2 ... tb_namen > file_name_to_save
Examples:
mysqldump carriermls_production users user_search_results > users_backup.sql
mysql carriermls_tmp < users_backup.sql
If you doesnt mentioned any name in tables option, you can dump entire database itself.
If you want to dump all mysql databases means, use the below commands:
mysqldump [options] --all-databasesmysqldump [options] --databasesdb_name1[db_name2db_name3...]