Skip to content

Instantly share code, notes, and snippets.

@olssonm
Created June 16, 2017 09:14
Show Gist options
  • Save olssonm/0bf7f7deefd38737bd522e3ccea1b0de to your computer and use it in GitHub Desktop.
Save olssonm/0bf7f7deefd38737bd522e3ccea1b0de to your computer and use it in GitHub Desktop.
Remove definer constraints on a a MySQL-dump in macOS
sed -i '' 's/DEFINER=`[^`][^`]*`@`[^`][^`]*`//g' filename.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment