only process post and triggers #1387
Unanswered
matthewlenz
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
When doing a dump I have it skip definers and when I load the database into a test environment I have it skip post (routines) and triggers. This allows me to load the database with a user who has more permissions (disable the redo log etc). The idea was to run the post/triggers manually but those files don't have use a DELIMITER statement which makes them incompatible with just cating the output it mysql using the lower privileged user so the triggers and routines get that user as the definer. Is it possible to run myloader in a way that it will ONLY run the post and trigger files?
Beta Was this translation helpful? Give feedback.
All reactions