Automatic MySQL backup in linux

Edit script file

[Python]

1. Db_user ="Root"
2. Db_passwd ="123456"
3. Db_host ="Localhost"
4. Backup_dir ="/Usr/local/apache2/htdocs/backup"
5. Time ="$ (Date +"% Y % m % d % H % M")"
6. MYSQL ="/Usr/local/mysql/bin/mysql"
7. MYSQLDUMP ="/Usr/local/mysql/bin/mysqldump"
8. MKDIR ="/Bin/mkdir"
9. RM ="/Bin/rm"
10. MV ="/Bin/mv"
11. GZIP ="/Bin/gzip"
12. Test! -W $ backup_dir & echo"Error: $ backup_dir is un-writeable ."& Exit0
13. Test! -D"$ Backup_dir/$ time"& $ MKDIR-p"$ Backup_dir/$ time"
14. All_db ="$ ($ MYSQL-u $ db_user-h $ db_host-p $ db_passwd-Bse 'show databases ')"
16. ForDbIn$ All_db
17. Do
18. $ MYSQLDUMP"-- Default-character-set = gbk"-U $ db_user-h $ db_host-p $ db_passwd $ db | $ GZIP-9>"$ Backup_dir/$ time/mongodb.gz"
19. Done
20. Exit0;

Set scheduled task

Use the crontab-e command to edit the scheduled task list

[Html]

1. 15 3 *** sh/usr/scripts/mysql_backup.sh

Indicates that the script is executed at 03:15 every day for database backup.