Shulou(Shulou.com)06/01 Report--

#! / bin/bash

MYUSER= "root"

MYPASS= "123456"

HOST= "localhost"

BACKUPDIR= "/ backup_mysql"

DATE= `date-I`

RETENTION=20

# MYSQLDATA= "/ var/lib/mysql"

[!-d $BACKUPDIR/$DATE] & & mkdir-p $BACKUPDIR/$DATE

DBS= `mysql-u$MYUSER-p$MYPASS-Bse "show databases" | grep-v "information_schema" | grep-v "test" `

For db_name in $DBS

Do

Mkdir-p $BACKUPDIR/$DATE/$db_name

Tables= `MySQL-u$MYUSER-p$MYPASS-Bse "use $db_name;show tables" `

For table_name in $tables

Do

Mysqldump-u$MYUSER-p$MYPASS-h$HOST-single-transaction-- master-data=2 $db_name $table_name > $BACKUPDIR/$DATE/$db_name/$table_name.sql

Done

Done

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.