You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
28 lines
780 B
28 lines
780 B
#!/bin/bash
|
|
|
|
# 备份目录
|
|
backup_path="/usr/local/Backup"
|
|
|
|
# 每次备份就清空重新创建
|
|
rm -rf ${backup_path}
|
|
mkdir -p /usr/local/Backup
|
|
cd $backup_path
|
|
|
|
# 数据库名称
|
|
db_name=base_db
|
|
# 数据库用户
|
|
db_user=root
|
|
# 数据库密码
|
|
db_pwd=DsideaL147258369
|
|
|
|
# 备份日期
|
|
date_str=`date +%Y%m%d`
|
|
|
|
# 备份表
|
|
mysqldump -u ${db_user} --password=${db_pwd} ${db_name} t_base_class_log t_base_organization_log t_person_duty_charge_log t_sys_loginperson_log t_transfer_apply_log | gzip > /usr/local/Backup/operator_log_${date_str}.sql.gz
|
|
|
|
# 切片
|
|
split -b 500m -d /usr/local/Backup/operator_log_${date_str}.sql.gz /usr/local/Backup/operator_log_${date_str}.sql.gz.
|
|
|
|
# 删除原文件
|
|
rm -rf /usr/local/Backup/operator_log_${date_str}.sql.gz |