Local mysql backups (one file per table)

> cat run_mysql_backup.sh
export backupsdir=/root/backup/[myapp]/mysql_backups
export d=`eval date +%Y%m%d`
mkdir -p $backupsdir/$d
for i in `echo "show tables" | mysql -h[host] -u root -p[pass] [dbname]|grep -v Tables_in_`;
do
echo $i; mysqldump --add-drop-table --allow-keywords -q -a -c -h[host] -u root -p[pass] [dbname] $i > $backupsdir/$d/$i.sql
rm -f $backupsdir/$d/$i.sql.gz
gzip $backupsdir/$d/$i.sql
done