- mysql
#!/bin/sh
time=$(date '+%Y%m%d')
mkdir -p /mnt/data/DBbackup/mysql/$time
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases devops | gzip > /mnt/data/DBbackup/mysql/$time/devops.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases devops-alpha | gzip > /mnt/data/DBbackup/mysql/$time/devops-alpha.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_base | gzip > /mnt/data/DBbackup/mysql/$time/ei_base.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_ctb_ops | gzip > /mnt/data/DBbackup/mysql/$time/ei_ctb_ops.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_dfc | gzip > /mnt/data/DBbackup/mysql/$time/ei_dfc.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_educational | gzip > /mnt/data/DBbackup/mysql/$time/ei_educational.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_eqs | gzip > /mnt/data/DBbackup/mysql/$time/ei_eqs.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_etp_dev | gzip > /mnt/data/DBbackup/mysql/$time/ei_etp_dev.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_exercise | gzip > /mnt/data/DBbackup/mysql/$time/ei_exercise.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_flight_deck | gzip > /mnt/data/DBbackup/mysql/$time/ei_flight_deck.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_formula | gzip > /mnt/data/DBbackup/mysql/$time/ei_formula.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_homework | gzip > /mnt/data/DBbackup/mysql/$time/ei_homework.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_homework_2022_0 | gzip > /mnt/data/DBbackup/mysql/$time/ei_homework_2022_0.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_homework_2022_1 | gzip > /mnt/data/DBbackup/mysql/$time/ei_homework_2022_1.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_homework_2022_2 | gzip > /mnt/data/DBbackup/mysql/$time/ei_homework_2022_2.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_homework_2022_3 | gzip > /mnt/data/DBbackup/mysql/$time/ei_homework_2022_3.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_laishan_project | gzip > /mnt/data/DBbackup/mysql/$time/ei_laishan_project.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_manage | gzip > /mnt/data/DBbackup/mysql/$time/ei_manage.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_marking_2022_0 | gzip > /mnt/data/DBbackup/mysql/$time/ei_marking_2022_0.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_marking_2022_1 | gzip > /mnt/data/DBbackup/mysql/$time/ei_marking_2022_1.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_marking_2022_2 | gzip > /mnt/data/DBbackup/mysql/$time/ei_marking_2022_2.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_marking_2022_3 | gzip > /mnt/data/DBbackup/mysql/$time/ei_marking_2022_3.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_marking_dev | gzip > /mnt/data/DBbackup/mysql/$time/ei_marking_dev.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_master | gzip > /mnt/data/DBbackup/mysql/$time/ei_master.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_report_2022_0 | gzip > /mnt/data/DBbackup/mysql/$time/ei_report_2022_0.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_report_2022_1 | gzip > /mnt/data/DBbackup/mysql/$time/ei_report_2022_1.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_report_2022_2 | gzip > /mnt/data/DBbackup/mysql/$time/ei_report_2022_2.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_report_2022_3 | gzip > /mnt/data/DBbackup/mysql/$time/ei_report_2022_3.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_report_dev | gzip > /mnt/data/DBbackup/mysql/$time/ei_report_dev.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_respondent_dev | gzip > /mnt/data/DBbackup/mysql/$time/ei_respondent_dev.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_separate_paper | gzip > /mnt/data/DBbackup/mysql/$time/ei_separate_paper.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_sms | gzip > /mnt/data/DBbackup/mysql/$time/ei_sms.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_tk | gzip > /mnt/data/DBbackup/mysql/$time/ei_tk.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_tk_algorithm_verify | gzip > /mnt/data/DBbackup/mysql/$time/ei_tk_algorithm_verify.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_tk_qa | gzip > /mnt/data/DBbackup/mysql/$time/ei_tk_qa.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_tkms | gzip > /mnt/data/DBbackup/mysql/$time/ei_tkms.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_topic_group_volume | gzip > /mnt/data/DBbackup/mysql/$time/ei_topic_group_volume.sql.gz
mysqldump -ueiduo -pxxxxxx --host=192.168.1.152 --set-gtid-purged=OFF --single-transaction --flush-logs --master-data=2 --databases ei_trade | gzip > /mnt/data/DBbackup/mysql/$time/ei_trade.sql.gz
before=$(date -d "2 days ago" '+%Y%m%d')
rm -rf /mnt/data/DBbackup/mysql/$before
echo 'Done!'
- mongodb备份
#!/bin/sh
time=$(date '+%Y%m%d')
mongodump -uroot -pxxxxxx --host=192.168.1.153 --port=27017 -o /mnt/data/DBbackup/mongodb/$time
cd /mnt/data/DBbackup/mongodb
tar -zcvf ./mongo-test-$time.tar.gz ./$time
rm -rf ./$time
before=$(date -d "2 days ago" '+%Y%m%d')
rm -f /mnt/data/DBbackup/mongodb/mongo-test-$time.tar.gz
echo 'Done!'
- 定时任务
[root@localhost ~]
[root@localhost ~]
[root@localhost ~]
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root
0 5 * * * root /mnt/data/DBbackup/mongodb/mongo-test.sh
0 7 * * * root /mnt/data/DBbackup/mysql/mysql-test.sh