Linux server automatically backs up MySQL database

1. Create a backup folder

Mkdir/var/lib/mysqlbackup  

2. Write backup script code

VI dbbackup.sh

3. Script Content

#!/bin/shmysqldump-uuser-ppassword dbname | gzip >/var/lib/mysqlbackup/dbname ' Date +%y-%m-%d_%h%m%s '. SQL.GZCD  /var/lib/mysqlbackup   rm-rf ' find.- Name ' *.sql.gz '-mtime '  #删除10天前的备份文件

4. Change Backup Script permissions

5. Execute backup script code with crontab timing

6, if every night 21 o'clock 00 Backup, add the following code,

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

Linux server automatically backs up MySQL database