Ignore tables in MySQLdump

While taking mysqldump  some time error coming like databaseName.tableName crossed.meanwhile time you have to exclude that tables.And you don't want to include  some tables while taking mysqldump.


For that we can use    "--ignore-table=DbName.TableName" infront of  DbName in mysqldump command.see below dump command

mysqldump -ruserName -ppassWord  ----ignore-table=DbName.TableName DbName > DbName.sql

This command exclude which table you need to omit.

You can exclude multiple table also

mysqldump -ruserName -ppassWord --ignore-table=DbName.TableName1 --ignore-table=DbName.TableName2 > database.sql

Example:

mysqldump -rroot -proot  ----ignore-table=TEST.TEST_DATA TEST > TEST.sql