backup mysql

mysql.sh

#!/bin/bash

# crontab:
# 30 */8 * * * /root/backup/mysql.sh


databases=(db1 db2 db3)

basepath='/root/backup/mysql/'

if [ ! -d "$basepath" ]; then
  mkdir -p "$basepath"
fi

for db in ${databases[*]}
  do
    /usr/bin/nice -n 19 /usr/bin/mysqldump -u root --password=[password here] --databases $db > $basepath$db-$(date +%Y-%m-%d_%H).sql

    /usr/bin/nice -n 19 gzip -f $basepath$db-$(date +%Y-%m-%d_%H).sql
    find $basepath -mtime +30 -name "*.sql.gz" -exec rm -rf {} \;
  done

  rm -rf $basepath/*.sql