Backup all dbs in separate files

backingMySQLDatabasesToMultipleFiles.sh

#!/bin/sh
# Backup all dbs in separate files
# adapted from
# http://www.usercore.com/backup-all-mysql-databases-as-seperate-sql-files/
# use mysqldump5 for MacPorts, mysqldump otherwise

user='root'
password='password'

to='/path/to/backup/folder' # without final /
for db in `mysql -u${user} -e "show databases" -B -N`
do
echo "Dumping $db"
mysqldump -u${user} --extended-insert=FALSE --master-data $db > 20120913_$db.sql
done

backup-all-databases-separate-files.sh

#!/bin/sh
# Backup all dbs in separate files
# adapted from
# http://www.usercore.com/backup-all-mysql-databases-as-seperate-sql-files/
# use mysqldump5 for MacPorts, mysqldump otherwise

user='user'
password='password'
to='/path/to/backup/folder' # without final /

for db in `mysql -u${user} -p${password} -e "show databases" -B -N`
do
  echo "Dumping $db"
  mysqldump5 -u${user} -p${password} $db | gzip > ${to}/${db}.sql.gz
done