MySQL – Ignore Tables from Backup in MySQLdump

Use –ignore-table option with the mysqldump command to ignore table for backup. 

Using this option, you need to specify both the database and table names as showing in the below example.

mysqldump --login-path=root -T /backup/mysql-files/ goyuninfo --ignore-table=goyuninfo.table_to_ignore1 --ignore-table=goyuninfo.table_to_ignore2

Or using --ignore-table and create an array of tables, with syntaxs like

--ignore-table={db_test1.table8,db_test2.table6,db_test3.table5}