mysql_utils

# enable logging to file
SET GLOBAL log_output = "FILE";
SET GLOBAL general_log_file = "/tmp/q_logfile.log";
SET GLOBAL general_log = 'ON';

# dump database
mysqldump --routines --single-transaction -q --add-drop-table --create-options --add-drop-database --disable-keys --extended-insert --set-charset {database_name} | gzip > {database_name}.sql.gz

# remove definer
perl -p -i.bak -e "s/DEFINER=[^ |\s]*//g" dbdumpfile.sql