A script is used to export all MySQL databases and save them to a specified location.
The contents are as follows:
| code is as follows |
&nbs P; |
| #!/bin/bash
############################################
#
# This is a MySQL database backup script
# One time export all databases and GZ compress save
# ccshaowei#gmail.com
# 2013/05/08
# http:// www.111cn.net#
############################################
# Backup directory
Backdir=/home/shaowei/dbbak
# Database login user name
dbuser= ' dbusername '
# Database login password
dbpass= ' dbpasswd '
# database location is usually/var/lib/mysql
dblist=$ (ls-p/V Ar/lib/mysql | grep/| tr-d/)
################ configuration End #################
today=$ (date +%y%m%d)
mkdir $backdir
mkdir $backdir/$tod Ay
for dbname in $dblist
######################################## #如果不需要显示压缩比, remove the-v parameter
do after gzip Mysqldump -u$dbuser-p$dbpass $dbname | Gzip-v > $backdir/$today/$dbname-$today. sql.gz
Echo $dbname ' OK ' #如果需要他默默的运行, comment out this line too
Done |
