Skip to content
This repository has been archived by the owner on Feb 3, 2022. It is now read-only.

Replace DEFINER in database dump #53

Open
adam-paterson opened this issue Apr 20, 2017 · 0 comments
Open

Replace DEFINER in database dump #53

adam-paterson opened this issue Apr 20, 2017 · 0 comments

Comments

@adam-paterson
Copy link
Contributor

adam-paterson commented Apr 20, 2017

Database dumps with store procedures or triggers contain their definer. When importing to another database where the definers might vary it causes issues. netz98/n98-magerun#130 tackled the issue by piping a stream edit and replacing the definer statements with a wildcard.

We could look into doing the same. How it's currently implemented and for performance reasons we'll probably need to look at using the native stream_filter functions and preg_replace the definer statements.

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

No branches or pull requests

1 participant