Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DB specific options: ignore-table #29

Open
wallacio opened this issue Jan 29, 2018 · 0 comments
Open

DB specific options: ignore-table #29

wallacio opened this issue Jan 29, 2018 · 0 comments

Comments

@wallacio
Copy link

This is a fairly specific requirement of mine but it opens up the possible need for other database-specific options.

I'm backing up databases which all contain a table that I don't need backing up and I currently specify this with --ignore-table. The --ignore-table option of mysqldump must specifiy both the the database name and the table so adding it in MYSQL_OPTS isn't going to work, as it is.

Needing this as a general option common to all databases being backed up is admittedly unlikely and it's only applicable to me because all the databases that I'm backing up are of the same schema (I don't even know what happens if you specify this option for a database that doesn't contain the table you want to ignore either).

Is it therefore worth considering this as a database-specific option in config? Something like:
MYSQL_OPTS_IGNORE_TABLE="db1_name.ignore_me db2_name.ignore_this db3_ignore_me"

It shouldn't be too hard to parse/match these and apply accordingly in the call to mysqldump.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant