Strip DEFINER comments from mysqldump. Usage is to pipe mysqldump through this sed command.

strip-definer-comments.md

Stripping DEFINER from MySQL dumps with sed

LC_ALL=C sed -E 's/DEFINER[ ]*=[ ]*`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g'

Typical Usage

pv /path/to/mysqldump.sql.gz \
  | gunzip -c \
  | LC_ALL=C sed -E 's/DEFINER[ ]*=[ ]*`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' \
  | mysql <database>

Occasionally More is Required

pv /path/to/mysqldump.sql.gz \
  | gunzip -c \
  | LC_ALL=C sed -E 's/DEFINER[ ]*=[ ]*`[^`]+`@`[^`]+`/DEFINER=CURRENT_USER/g' \
  | LC_ALL=C sed -E 's/ROW_FORMAT=FIXED//g' \
  | LC_ALL=C sed -E '/\@\@(GLOBAL\.GTID_PURGED|SESSION\.SQL_LOG_BIN)/d' \
  | mysql <database>