A way to back up the entire MySQL database using crontab timing

1. Configure the backup directory on the server

Mkdir/data/mysqlbackup

2. Write backup script code

VI dbbackup.sh

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

Here's an example of backing up the entire database

Code:

#!/bin/sh

Mysqldump-uuser-ppassword--single-transaction--events--triggers--routines--all-databases | gzip >/data/mysqlbackup/all-databases-' Date +%y-%m-%d_%h%m%s '. sql.gz

Cd/data/mysqlbackup

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



3. Change Backup Script permissions


chmod +x dbbackup.sh


4. Execute backup script code with crontab timing

Crontab-e


If you are backing up 23:00 every night, add the following code


XX * * */root/dbbackup.sh

This article is from the "Behind" blog, make sure to keep this source http://merrycheng.blog.51cto.com/5331300/1689238

A way to back up the entire MySQL database using crontab timing