How to back up MySQL database using crontab timer

First step: Configure the backup directory code on the server:

--------------------------------------------------------------------------------

Mkdir/var/lib/mysqlbackup

Cd/var/lib/mysqlbackup

--------------------------------------------------------------------------------

Step Two: Write the backup script code:

--------------------------------------------------------------------------------

VI dbbackup.sh

--------------------------------------------------------------------------------

Paste the following code, and make sure to change the Username,password and dbname.

Code:

--------------------------------------------------------------------------------

#!/bin/sh

Mysqldump-uuser-ppassword dbname | gzip >/var/lib/mysqlbackup/dbname ' Date +%y-%m-%d_%h%m%s '. sql.gz

Cd/var/lib/mysqlbackup

Rm-rf ' Find. -name ' *.sql.gz '-mtime ' #删除10天前的备份文件

--------------------------------------------------------------------------------

Step Three: Change backup script permissions

Code:

--------------------------------------------------------------------------------

chmod +x dbbackup.sh

--------------------------------------------------------------------------------

Fourth step: Execute the Backup script code with CRONTAB timing:

--------------------------------------------------------------------------------

Crontab-e

--------------------------------------------------------------------------------

If you are backing up at 21 o'clock 00 every night, add the following code

Code:

--------------------------------------------------------------------------------

* * * * */var/lib/mysqlbackup/dbbackup.sh

How to back up MySQL database using crontab timer