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:
1.5G /var/lib/mysql/db/phpbb_search_wordmatch.MYI
216M /var/lib/mysql/db/phpbb_search_wordmatch.MYD
Almost 2GB for a table that can easily be rebuilt if lost.
305M /var/lib/mysql/db/cache_render.ibd
589M /var/lib/mysql/db/cache_dynamic_page_cache.ibd
953M /var/lib/mysql/db/cache_page.ibd
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.
Hi Justin,
Thank you for submitting your request and detailed information you provided :)
Our development team will be reviewing your request and will provide an update here accordingly.
Thank You,
JetApps Team
Hi Justin,
Thank you for submitting your request and detailed information you provided :)
Our development team will be reviewing your request and will provide an update here accordingly.
Thank You,
JetApps Team
I literally asked the devs to include something like this specifically for phpBB and its phpbb_search_wordmatch table that on one of our websites is around 8GB in size, and we have zero need for backing it up at all.
Would love to see this implemented sooner rather than later...
I literally asked the devs to include something like this specifically for phpBB and its phpbb_search_wordmatch table that on one of our websites is around 8GB in size, and we have zero need for backing it up at all.
Would love to see this implemented sooner rather than later...
This is a much needed feature, as many instances exist where a very large database table doesn't need to be backed up. Please add this feature, as you're already supporting it in your Linux version of JetBackup.
This is a much needed feature, as many instances exist where a very large database table doesn't need to be backed up. Please add this feature, as you're already supporting it in your Linux version of JetBackup.
Me too
Me too
Replies have been locked on this page!