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

Error: 1227 SQLSTATE: 42000 Access denied - thrown when dumping database with triggers #61

Closed
michalbiarda opened this issue Jan 24, 2023 · 0 comments
Assignees
Labels
Milestone

Comments

@michalbiarda
Copy link
Contributor

More info: https://aws.amazon.com/premiumsupport/knowledge-center/definer-error-mysqldump/

We tried to set the log_bin_trust_function_creators parameter to true as suggested in the article, but it didn't fix the issue.

Idea for a workaround: dump whole database w/o triggers, then dump only triggers, process the first dump, at the end concatenate both.

Known issue: If some environment ignores a table with trigger, the error might occur during dump import.

@michalbiarda michalbiarda added this to the 4.0.0 milestone Jan 24, 2023
@michalbiarda michalbiarda self-assigned this Jan 24, 2023
michalbiarda added a commit that referenced this issue Jan 26, 2023
@michalbiarda michalbiarda moved this to In Progress in Driver Jan 31, 2023
@michalbiarda michalbiarda moved this from In Progress to Done in Driver Jan 31, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
Status: Done
Development

No branches or pull requests

1 participant