Skip to content

Instantly share code, notes, and snippets.

@zaifastafa

zaifastafa/Removing DEFINER from sql

Last active July 5, 2023 11:56
Show Gist options
  • Save zaifastafa/79435a44930ed73b89535a294912386b to your computer and use it in GitHub Desktop.
Save zaifastafa/79435a44930ed73b89535a294912386b to your computer and use it in GitHub Desktop.
Download ZIP
For removing DEFINER clause from mysql dump
Raw
Removing DEFINER from sql
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