Source: https://stackoverflow.com/a/16466591/2535504
mysqldump -u user -p db | grep -v "50013 DEFINER" > dump.sql
mysql -u user -p db_clone < dump.sql
Created
May 22, 2021 05:04
-
-
Save shengslogar/cde6a0a5067a73d69f156fe191e9188b to your computer and use it in GitHub Desktop.
Copy MySQL database while excluding limiting security definers
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment