To ignore certain tables, you can use the --ignore-table=database.table option. To specify more than one table to ignore, use the directive multiple times:
shell> mysqldump --databases employees --ignore-table=employees.salary > employees_backup.sql
Ignore tables
Get MySQL 8 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
