Sometimes it happens that you need to ignore a table from backup due to any reason like 1. Table size is big, we keep log in that data. 2. Table that don't need to copy in backup. 3. Database copying from prod to test and some tables don't need in backup file. Generally when we create backup in single dump file it consolidate all db schema and data and if we need to exclude any table of sets of tables, then we need to use "--ignore-table" clause in mysqldump command. Syntax is as below. mysqldump -h <host> -u <username> -p <schema> --no-create-info --ignore-table=schema.table1 > db-data.sql Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757
Connecting, Sharing and Discovering