#!/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