Centos script automatically backs up databases

Centos script automatically backs up databases

Write scripts

[Plain] view plaincopy

1. [Root @ iZ232s4zbqvZservice] # vimysql_dump.sh
2. #! /Bin/sh
4. Echo "mysqldumpstart ..."
6. DB_NAME = "imms_core"
7. DB_USER = "root"
8. DB_PASS = "smithhuang"
9. BIN_DIR = "/usr/bin"
10. YEAR = 'date + % y'
11. BCK_DIR = "/data/mysql_dump/" $ YEAR/
12. DATE = 'date + % Y % m % d _ % H % M % s'
13. Mkdir-p $ BCK_DIR
15. $ BIN_DIR/mysqldump-u $ DB_USER-p $ DB_PASS $ DB_NAME | gzip> $ BCK_DIR/mongodb_name.dump_1_date. SQL .gz
16. Sleep1
18. #####
19. DB_NAME = "imms_app"
20. $ BIN_DIR/mysqldump-u $ DB_USER-p $ DB_PASS $ DB_NAME | gzip> $ BCK_DIR/mongodb_name.dump_1_date. SQL .gz
22. Echo "mysqldumpendat" $ DATE

Note:

Directory/data/mysql_dump/and directory/data/logs/mysql should have www user permissions, and it is best to change it to 777 permissions.

Add the script to the scheduled task (last line) (executed at every day)

Switch to the www user first

[Plain] view plaincopy

1. [Www @ iZ232s4zbqvZ ~] $ Crontab-e
3. # Immsmysqldump
4. 0101 ***/usr/local/service/mysql_dump.sh>/data/logs/mysql/mysqldump. log

Use gunzip to decompress the archive before restoration.

For example:

[Root @ iZ232s4zbqvZ 2015] # gunzip imms_core.dump_20150211_133301. SQL .gz