Database Backup Program. There are three general ways to invoke mysqldump


shell> mysqldump [options] db_name [tbl_name ...]
shell> mysqldump [options] --databases db_name ...
shell> mysqldump [options] --all-databases

Examples for creating mysql dump
mysqldump -user root -password=myrootpassword db_test db_second db_third > db_test.sql