mysql--using the script to realize the sub-database sub-table backup

#!/bin/bash

User=root

passwd=123456

Sock=/data/3306/mysql.sock

login= "Mysql-u$user-p$passwd-s $SOCK"

Database= ' $LOGIN-e "show databases; | Sed ' 1d ' |egrep-v ". *schema|mysql" '

dump= "Mysqldump-u$user-p$passwd-s $SOCK"

#cd/backup/mysql/

For database in $DATABASE;d o

[!-D $database] && mkdir-p/backup/mysql/$database

$DUMP-B $database | gzip >/backup/mysql/$database/${database}_$ (date +%f). sql.gz

Table= ' $LOGIN-e "show tables from $database;" | Sed ' 1d '

For table in $TABLE;d o

$DUMP $database $table | gzip >/backup/mysql/$database/${database}_${table}_$ (date +%f). sql.gz

Done

Done

Combined with scheduled tasks, you can fully automate backups

This article is from the "burning Years of Passion" blog, please be sure to keep this source http://liuzhengwei521.blog.51cto.com/4855442/1763254

mysql--using the script to realize the sub-database sub-table backup