Skip to content

Instantly share code, notes, and snippets.

@sodonnell

sodonnell/f.u.amazon.rds.super.privs.sh

Created July 24, 2018 17:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sodonnell/ac061aaf7e75163ac84f15ef3195222a to your computer and use it in GitHub Desktop.
Save sodonnell/ac061aaf7e75163ac84f15ef3195222a to your computer and use it in GitHub Desktop.
Download ZIP
Amazon RDS doesn't like DEFINER statements from mysqldump when creating views. ^&*$^#*&$
Raw
f.u.amazon.rds.super.privs.sh
sed -i 's/\/\*[^*]*DEFINER=[^*]*\*\///' dump2rds.sql
@sodonnell
Copy link
Author

sodonnell commented Jul 24, 2018 •
edited

...and of course, mysqldump in v5.7 supports the --skip-definer option.

Yet another reason I can't wait to get this old DB migrated/upgraded. Don't even think of mentioning xtrabackup here. I already know. =P

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