Backup certain tables in MySQL Is it possible to take backup of certain table in mysql? Suppose I have 10 tables, and I want to take a backup of 8 tables through one command. 

How can I do this?
mysqldump -u username -p databasename table1 table2 table3


or

mysqldump --opt -u username -p databasename table1 table2 table3