Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to achieve automatic backup in mysql. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

Mysql automatic backup scheme

I. configure the server

1. Write an automatic backup script

Mysql backup mainly includes hot backup and cold backup. Hot backup is used here, that is, backup is carried out by using mysqldump to export SQL statements.

# vi / etc/mysqlback.sh

#! / bin/bash www.2cto.com

DB_NAME= "luwenju" / / databases to be backed up

DB_USER= "luwenju" / / Database user name

DB_PASS= "luwenju" / / Database password

Environment variables for BIN_DIR= "/ usr/local/mysql/bin" / / mysql

BACK_DIR= "/ opt" / / backup file saves data

DATE= "`date +% Y% m% d`"

$BIN_DIR/mysqldump-opt-u$DB_USER-p$DB_PASS $DB_NAME > $BACK_DIR/luwenju_$DATE.sql

# chmod + x / etc/mysqlback.sh

test

# / etc/mysqlback.sh

# ls / opt/

Luwenju_20110626.sql

2. Set the scheduled backup cycle

In this case, the backup is set up once a day in the early morning, and the specific backup cycle is based on the specific application.

# crontab-e

0 0 * / etc/mysqlback.sh

# / etc/init.d/crond restart

3. Install rsync

# tar zxvf rsync-3.0.8.tar.gz

# cd rsync-3.0.8

#. / configure & & make & & make install

Create a configuration file and add the following

# vi / etc/rsync.conf

Uid = nobody www.2cto.com

Gid = nobody

Use chroot = no

Max connections = 10

Pid file = / var/run/rsyncd.pid

Lock file = / var/run/rsyncd.lock

Log file = / var/log/rsyncd.log

Port = 873

Timeout = 300

[backup]

Read only = yes / / read-only mode

List = yes

Ignore errors

Comment = This is a file back

Path = / opt / / directories to be synchronized

Auth users = test / / authenticate user

Secrets file = / etc/rsync.passwd / / verify the password path

Hosts allow = 119.232.33.246 / / clients allowed to connect

The above is how to achieve automated backup in the mysql shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.