Remove DEFINER clause from MySQL Dumps

Question

I have a MySQL dump of one of my databases  In it  there are DEFINER clauses which look like     DEFINER  root   localhost      Namely  these DEFINER clauses are on my CREATE VIEW and CREATE PROCEDURE statements  Is there a way to remove these DEFINER clauses from my dump file

User · Answer

I don t think there is a way to ignore adding DEFINERs to the dump  But there are ways to remove them after the dump file is created       Open the dump file in a text editor and replace all occurrences of DEFINER root localhost with an empty string     Edit the dump  or pipe the output  using perl     perl -p -i bak -e  s DEFINER    w        d 0-3    0-3     g  mydatabase sql    Pipe the output through sed     mysqldump       sed -e  s DEFINER                       gt  triggers backup sql

[mysql] Remove DEFINER clause from MySQL Dumps

Examples related to mysql