Centos script automatically backs up databases

Compile the script [plain] viewplaincopy [root @ iZ232s4zbqvZservice] # vimysql_dump.sh #! /Bin/sh

Write scripts

[Plain]View plaincopy

1. [Root @ iZ232s4zbqvZ service] # vi mysql_dump.sh
2. #! /Bin/sh
4. Echo "mysqldump start ..."
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_mongodate. SQL .gz
16. Sleep 1
18. #####
19. DB_NAME = "imms_app"
20. $ BIN_DIR/mysqldump-u $ DB_USER-p $ DB_PASS $ DB_NAME | gzip> $ BCK_DIR/mongodb_name.dump_mongodate. SQL .gz
22. Echo "mysqldump end at" $ 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. # Imms mysqldump
4. 01 01 ***/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