#!/bin/bash #description :this is script use to backup mysql #script name : mysql_backup.sh #author :mds #date : 2014.07.17 #e-mail : 1455975151@qq.com backup_dir=/opt/mysqlbackup time=$(date +"%F-%T") db_user="root" db_password="strong" db_host="localhost" #mkdir $backup_dir all_db="$(mysql -u$db_user -p$db_password -h$db_host -Bse 'show databases')" for db in $all_db do mysqldump -u$db_user -p$db_password -h$db_host $db | gzip > "$backup_dir/$time.$db.sql.gz" done
转载于:https://blog.51cto.com/madsstudy/1439657