MySQL Data backup script

#!/bin/bash

#MySQL备份

dates= ' Date +%y%m%d '

datey= ' date-d ' days Ago "+%y%m%d"

Mkdir-p/home/backup

Cd/home/backup

Mysqldump-uroot-pwyqj_root fight_cancer > Fight_cancer. $dates. sql

Mysqldump-uroot-pwyqj_root redmine > Redmine. $dates. sql

Mkdir-p/home/backup/fight_cancer

Mkdir-p/home/backup/redmine

Gzip fight_cancer. $dates. sql

Gzip redmine. $dates. sql

MV Fight_cancer. $dates. Sql.gz/home/backup/fight_cancer

MV Redmine. $dates. Sql.gz/home/backup/redmine

Rm-rf/home/backup/fight_cancer/fight_cancer. $datey. sql.gz

Rm-rf/home/backup/redmine/redmine. $datey. sql.gz