定时备份表

小冰-HelloWorld

已于 2022-01-22 20:54:11 修改

阅读量176

点赞数

分类专栏： MySQL Linux 文章标签：数据库 database

于 2018-11-10 23:49:07 首次发布

本文链接：https://blog.csdn.net/bingxue_xuebing/article/details/83934545

版权

Linux 同时被 2 个专栏收录

17 篇文章 0 订阅

订阅专栏

MySQL

12 篇文章 0 订阅

订阅专栏

#!/bin/bash

HOST=localhost
USER=root
PASSWORD=123456
DATABASE=test
BACKUP_PATH=/opt/pivotal_table_bk

echo "back up table start"
time=$(date "+%Y%m%d-%H%M%S")
echo "${time}"
mysqldump -u$USER -p$PASSWORD test trust_next_loan_lot>$BACKUP_PATH/trust_next_loan_lot-${time}.sql
mysqldump -u$USER -p$PASSWORD test trust_apply_info>$BACKUP_PATH/trust_apply_info-${time}.sql
mysqldump -u$USER -p$PASSWORD test trust_loan_detail_item>$BACKUP_PATH/trust_loan_detail_item-${time}.sql
mysqldump -u$USER -p$PASSWORD test busi_trust_loan_detail>$BACKUP_PATH/busi_trust_loan_detail-${time}.sql
echo "back up table end"

定时任务crontab
# Example of job definition:
# .---------------- minute (0 - 59)
# |  .------------- hour (0 - 23)
# |  |  .---------- day of month (1 - 31)
# |  |  |  .------- month (1 - 12) OR jan,feb,mar,apr ...
# |  |  |  |  .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# |  |  |  |  |
#*  *  *  *  * user-name  command to be executed
55 17 * * * root /opt/scripts/table_backup.sh