Skip to content

Instantly share code, notes, and snippets.

@nikolazic
Created March 4, 2014 22:54
Show Gist options
  • Save nikolazic/9357466 to your computer and use it in GitHub Desktop.
Save nikolazic/9357466 to your computer and use it in GitHub Desktop.
Fix issue with trigger definers in magento
mysqldump --single-transaction -u guest -ppassword riot | sed -E 's/DEFINER=`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' | mysql -u guest -ppassword riot2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment