MySQL automatic backup script in Linux-first version

I wrote a MySQL backup script in Linux. This is the first version. Only one database can be backed up. Every night at, I run the script with a timer and it will be automatically backed up. In the future, multiple databases can be backed up. If the backup fails, text messages will be sent to the mobile phone and expired backups will be cleared automatically.

MySQL automatic backup script in Linux-Version 2

1. #! /Bin/bash
   
2. # Script: backup_mysql
   
3. # Version: Release 1.0
   
4. # Author: www.dba-china.com
   
5. # Date: 2011-10-26
   
6. 
   
7. Backup_time = 'date + % Y % m % d % H % m' # define the backup detailed time
   
8. Backup_Ymd = 'date + % Y % m % d' # define the year, month, and day time in the Backup Directory
   
9. Backup_7ago = 'date-d' 7 days ago '+ % Y % m % d' # date before seven days
   
10. Backup_dir =/backup/mysql/$ backup_Ymd # Full backup folder path
    
11. Backup_database = "dba-china" # Name of the database to be backed up
    
12. Mysql_user = "root"
    
13. Mysql_password = "root"
    
14. # Mysql_host = "localhost"
    
15. # MySQL _ Port = "3306"
    
16. 
    
17. # Determine whether MYSQL is started. If mysql is not started, the backup will exit.
    
18. Mysql_ps = 'ps-ef | grep mysql | wc-l'
    
19. Mysql_listen = 'netstat-an | grep LISTEN | grep $ mysql_port | wc-l'
    
20. If [[$ mysql_ps = 0]-o [$ mysql_listen = 0]; then
    
21. Echo "ERROR: MySQL is not running! Backup stop! "
    
22. Exit;
    
23. Else
    
24. Echo "MySQL running OK! "
    
25. Fi
    
26. 
    
27. # Connect to the mysql database. If the connection fails, the backup will exit.
    
28. Mysql-u $ mysql_user-p $ mysql_password <end
    
29. Use mysql;
    
30. Select host, user from user where user = 'root' and host = 'localhost ';
    
31. Exit
    
32. End
    
33. 
    
34. Flag = 'echo $? '
    
35. If [$ flag! = "0"]; then
    
36. Echo "error: Can't connect mysql server! Backup stoped! "
    
37. Exit;
    
38. Else
    
39. Echo "MySQL connect OK! Backup start ......"
    
40. # Db = 'echo $ backup_database | cut-d', '-f1'
    
41. Db = $ backup_database
    
42. If [$ db = '']; then
    
43. Echo "ERROR: no database to backup! "
    
44. Else
    
45. Echo "database $ db backup start ..."
    
46. 'Mkdir-p $ backup_dir'
    
47. 'Mysqldump-u $ mysql_user-p $ mysql_password $ db> $ backup_dir/$ db $ backup_time. SQL'
    
48. Echo "database $ db backup success! "
    
49. Fi
    
50. 
    
51. Fi