Automatic Backup of MySQL database and Email sending practice

The following articles mainly introduce the actual operation scheme of automatic backup of MySQL database and sending it to Email. We all know that automatic backup of MySQL database is widely used, is it very important to use it and send it to Email?

Databases are the most important part of a website. Therefore, it is necessary to back up data frequently.

So I wrote a script to automatically back up the MySQL database, and added the G-level mailbox gmail to back up the data as much as possible. The following code is as follows:

 
 

  
  
MySQLdump -uuser -ppassword --databases db1 > /home/website/backups/databackup.sql  
  
  
tar zcf /home/website/backups/databackup.sql.tar.gz /home/website/backups/ 
 
 

Echo "Topic: Database Backup"

 
 

  
  
| mutt -a /home/website/backups/databackup.sql.tar.gz -s " 
 
 

Content: Database

 
 

  
  
" www@gmail.com  
  
  
rm -r /home/website/backups/*  
 
 

Save the above Code as autoMySQLbackup. sh

Then, use crontab to implement dynamic backup. Under ssh,

 
 

  
  
crontab -e  
 
 

Enter the following content:

 
 

  
  
00 00 * * * /home/website/autoMySQLbackup.sh  
 
 

In this way, the MySQL database is automatically backed up at every day and sent to the Email

Let's briefly describe it.

The first sentence is to back up multiple databases at a time. This requires you to use the root permission .. -u is followed by the database user name-p followed by the database password without spaces db1 db2 db3 for the database name you need to back up.

If your database user name does not have the root permission, you can change it to this way.

 
 

  
  
MySQLdump -uuser -ppassword db1 > /home/website/backups/db1.sql  
  
  
MySQLdump -uuser -ppassword db2 > /home/website/backups/db1.sql  
  
  
MySQLdump -uuser -ppassword db3 > /home/website/backups/db1.sql  
 
 

The second sentence is to compress the data file in the backups folder into the file name: databackup. SQL .tar.gz

The third sentence is to send the compressed MySQL database file to the specified mailbox .....

The topic is database backup, which is the subject of the email. The content is database backup, which is used in the email,

/Home/website/backups/databackup. SQL .tar.gz is the attachment