#!/bin/bash

# 获取当前时间
time2=$(date "+%Y%m%d%H%M")
echo "Current time: $time2"

# 数据库名称
mysqldataname="jeesite"
echo "Database name: ${mysqldataname}"

# 拼接备份文件名
bakfilename="${mysqldataname}_${time2}"
echo "Backup filename: ${bakfilename}"

# 文件存放路径
filepath="/data/mysqlbak/$mysqldataname"
mkdir -p $filepath
cd $filepath
# 备份语句(--ignore-table参数，需要用 数据库名称.表名)
mysqldump -h 127.0.0.1 -uroot -p"aswdefjk1213" --single-transaction --ignore-table=jeesite.t_sys_record ${mysqldataname} > "${bakfilename}.sql"
tar -czf "${bakfilename}.tar.gz" "${bakfilename}.sql"
rm -f "${bakfilename}.sql"

# 打印成功消息
echo "Success ${bakfilename}.tar.gz"