Exclude or Include table(s) during creating backup from MySQL

 To exclude tables when you are creating database backup from MySQL, execute below query.

mysqldump -u root -p<Password> DATABASENAME --ignore-table=DATABASENAME.TABLENAME > BACKUPFILENAME.sql

 To include tables when you are creating database backup from MySQL, execute below query.

mysqldump -u root -p<Password> DATABASENAME TABLENAME1 TABLENAME2 > BACKUPFILENAME.sql

Take note that there is no whitespace between -p and the password..