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

A simple mysql full backup script that backs up data from the last 15 days.

Backup

# backup the mysql database every day (save the data script for the last 15 days)

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

/ home/cuixiaohuan/lamp/mysql5/bin/mysqldump-uuser-ppassword need_db > / home/cuixiaohuan/bak_sql/mysql_dbxx_$DATE.sql

Find / home/cuixiaohuan/bak_sql/-mtime + 15-name'* .sql'- exec rm-rf {}\

Restore

Mysql data Import

Drop databases need_db

Create databases need_db

Import data: encoding must be set for recovery

. / mysql-uroot-p-- default-character-set=utf8 need_db

> mysqldump-u username-p dbname table1 table2... > BackupName.sql

An example shows:

Mysqldump-u root-p test person > / tmp/backup.sql

3. Back up multiple databases

Basic syntax:

Mysqldump-u username-p-- databases dbname2 dbname2 > BackupName.sql

An example shows:

Mysqldump-u root-p-- databases test mysql > / tmp/backup.sql

4. Back up all databases

Basic syntax:

Mysqldump-u username-p-all-databases > BackupName.sql

An example shows:

Mysqldump-u-root-p-all-databases > / tmp/all.sql

5. Data recovery

Basic syntax:

Mysql-u root-p [dbname] < backup.sql

An example shows:

Mysql-u root-p < / tmp/backup.sql

These are the details of mysql full backup and fast recovery methods. For more information about mysql simple full backup and fast recovery methods, please pay attention to other related articles!

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.