mysql per database backup without mysql.event warning

mysql_backup

#!/bin/sh -

# this script is from https://gist.github.com/timkuijsten/6067107
# The important part is not to put the password as an argument to the mysql
# commands, i.e. don't use the -p option. Instead use a .my.cnf file in the home
# dir of the user you are running this script as, i.e. /home/records/.my.cnf if running
# as root. Make the file readable for the owner only: chmod 400 /home/records/.my.cnf
# See: http://stackoverflow.com/questions/17829659/securing-backup-credentials-for-mysqldump/17844997#17844997

umask 007

renice 10 $$ >/dev/null

BACKUPPATH=/home/records/backups/databases
DBHOST=transcription.cqh1pxtqzzth.us-east-1.rds.amazonaws.com

for db in `mysql --batch --skip-column-names -h "$DBHOST"  -u backup --execute="SHOW DATABASES" | egrep -v 'performance_schema|information_schema'`; do
  /usr/bin/nice /usr/bin/mysqldump --events --triggers --routines --triggers --ignore-table=mysql.event --single-transaction --quick --extended-insert  -h "$DBHOST"  -u backup  $
done