Automatically back up MySQL

The first step: Create a batch named Backmysql saved in/wwwroot/backup/with the following contents:

Backdate= ' Date +%y%m%d ' mysqldump database name-u user name-p password >/wwwroot/backup/$backDate. Sqltar zcvf $rq. tar.gz $rq. SQLRM $rq. sql

Statement Description:

1, define the variable backdate, take value for the day, such as 20150203

2. Backing Up the database

3. Compress database files

4. Delete the. sql file

Step Two: Open/etc/crontab, add a line of statements 2 * * * root/wwwroot/backup/backmysql

Statement Description: Backmysql files are automatically executed every 2:30, back up the database

Automatically back up MySQL