Sub-Library Backup (shell) for full-scale backup

Mkdir/server/script

Cd/server/script

VI mysql_backup_db.sh

#!/bin/sh
mysql_backup_dir=/data/mysql_backup/$ (Date +%f)
[!-D ${mysql_backup_dir}] && mkdir-p ${mysql_backup_dir}
User_pass= '-u root-pyeqing '
mysql_login= ' MySQL ${user_pass}-e "show Databases" |sed ' 1,2d '
For dbname in ${mysql_login}
Do
Mysqldump ${user_pass}-f-b ${dbname}|gzip > ${mysql_backup_dir}/${dbname}_$ (Date +%f). sql.gz
Done

chmod u+x mysql_backup_db.sh

./mysql_backup_db.sh

This article from the "Technical cock Silk" blog, reproduced please contact the author!

Sub-Library Backup (shell) for full-scale backup