mysqldump exclude specific tables with --ignore-table

Justin shared this idea 4 years ago
Under Consideration

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.

Replies (4)

photo
1

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

photo
1

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...

photo
1

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.

photo
1

Me too

Leave a Comment
 
Attach a file