Mysqldump backup to exclude the specified Table

Sometimes you do not want to back up a table when using mysqldump to back up the entire database. You can add -- ignore-table = database. the tablename parameter indicates that the entire database is backed up after the table is backed up. The following code is used for demonstration:

Mysqldump-uroot-p123456 dbname -- ignore-table = dbname. tablename> dump. SQL
-- Ignore-table = dbname. tablename is the table to be excluded. You can specify multiple tables to write multiple tables -- ignore-table = dbname. tablename1 -- ignore-table = dbname. tablename2 -- ignore-table = dbname. tablename3