Mysql Command to take Dump of Selected Tables in the Mysql Database

If you wish to take dump of on few tables such as table1, table2 & table3 use the command

mysqldump -u mysqlusername -p databasename table1 table2 table3 > databasebackup.sql

If you wish to take backup of the database by ignoring specific tables such as table1 and table2 and generate the dump containing all the tables.
Use the following command.

mysqldump -u username -p database –ignore-table=database.table1 –ignore-table=database.table2 > database.sql

If you have multiple database use the following command.

mysqldump -u user -p –ignore-table=database1.table1 –ignore-table=database2.table2 –databases database1 database2