# mysqlgodump

**Repository Path**: hh688/mysqlgodump

## Basic Information

- **Project Name**: mysqlgodump
- **Description**: No description available
- **Primary Language**: Go
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-08-15
- **Last Updated**: 2025-08-15

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# mysqlgodump

#### 介绍
windows下利用mysqldump进行备份的go脚本，可通过企微通知备份状态。

#### 用法

下载命令并解压
```
https://gitee.com/hh688/mysqlgodump/releases/download/v3.2-win-x86-64/mysqlgodump.zip
```


命令同目录下创建配置文件
vim backup.cnf
```
# MySQL连接配置
host = 127.0.0.1
port = 3306
user = test
password = 123456

# mysqldump路径
mysqldump_path = D:\mysql_servers\mysql\bin\mysqldump.exe

# 备份类型 (full/database/table)
backup_type = database

# 备份目标配置 (可选)
databases = test
tables = t2
# mysqldump参数
backup_options = -R -E --triggers --source-data=2  --single-transaction --set-gtid-purged=OFF

# 存储路径
backup_dir = D:/backup
log_dir = D:/backup/logs

# 备份保留天数
expire_days = 180

# 压缩级别 (0-9, 0=不压缩)
compress_level = 9

# 通知配置
notify_enable = true
notify_all = true
webhook_url = https://oapi.dingtalk.com/robot/send?access_token=test
# 提示信息
prompt = mysql:10.8.8.88:3306

```

```
cmd 命令行 进入到命令目录

./mysqlgodump

```