mysqldump exclude specific tables with --ignore-table
add the option for mysqldump '--ignore-table'
We find a fair amount of database that contains table that are quite large, usually tables that contains logs or cache. Example:
Almost 2GB for a table that can easily be rebuilt if lost.
Another 2GB~ in tables that can be rebuilt if lost.
There is no wildcard ability with --ignore-table but if we could specify to exclude these tables globally and individually would be nice.
It would also be nice if we could specify a wildcard primarily because of prefixes so while mysqldump doesn't support it you could basically check the tables first, if there is a match then add --ignore-table for each table that matches.