grimzy/make_portable_dump.sh

Created March 20, 2018 19:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/grimzy/ac4f33589e304f4c293aee76fc9c58d2.js"></script>
Save grimzy/ac4f33589e304f4c293aee76fc9c58d2 to your computer and use it in GitHub Desktop.

Download ZIP

Portable MySQL dump

Raw

make_portable_dump.sh

	mysqldump database_name > database_dump.sql

	sed -E 's/DEFINER=`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' database_dump.sql > portable_database_dump.sql

Author

grimzy commented Mar 20, 2018

For when we try to import a MySQL dump and get the following error: The user specified as a definer ('srv_master'@'localhost') does not exist

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment