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

Back up the mysql database

#! / bin/bash

BPATH=/home/backup/mysql_bak

USER= "root"

PASSWD= "123456"

HOST= "192.168.1.5"

DATE=$ (date +% Y-%d-%m)

If [!-d "$BPATH"]; then

Mkdir-p $BPATH

Fi

DB=$ (mysql-u $USER-h $HOST-p $PASSWD-Bse 'show databases')

For database in $DB

Do

If [! $database = = "information_schema"

Mysqldump-u $USER-h $HOST-P $PASSWD $database | bzip2 > "$BPATH/$ {DATE} _ mysql.gz"

Fi

Done

Import database

#! / bin/bash

BPATH=/home/backup/mysql_bak

USER= "root"

PASSWD= "123456"

HOST= "192.168.1.5"

Cd $BPATH

Tar zxf all_mysql.tar.gz

Mysqldump-u $USER-h $HOST-P $PASSWD < mysql.sql

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.