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

Automatic backup of mysql database scripts

#! / bin/sh

# NCONF database backup

# Script by Chen

# add (and adapt) the following line to the corresponding user's crontab:

# 50 23 * / usr/local/nconf/ADD-ONS/backup_db.sh

# MYSQL connection parameters (see config/mysql.php)

DBHOST=localhost

DBPORT=3306

DBNAME=test

DBUSER=user

DBPASS=pass

# Other variables

DESTINATION=/usr/local/nconf/BACKUP/db

DATE= `date +% Y% m% d% H% M% S`

KEEPDAY=30

# run backup

Mysqldump-- host=$DBHOST-- port=$DBPORT-u $DBUSER-- password=$DBPASS-- single-transaction $DBNAME | gzip > $DESTINATION/$DBNAME-$DATE.sql.gz

# delete old backups

Find $DESTINATION/-type f-name "$DBNAME-*.sql.gz"-mtime + $KEEPDAY-exec rm {}\

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.