53 lines
1.4 KiB
YAML
53 lines
1.4 KiB
YAML
# ============================================================
|
|
# 表结构对齐技能配置文件
|
|
# ============================================================
|
|
# 源数据库：准生产（只读）
|
|
# 目标数据库：VPS（root 可写）
|
|
# ============================================================
|
|
|
|
# 源数据库配置（准生产 - 只读）
|
|
sources:
|
|
- name: 准生产
|
|
host: 100.115.195.188
|
|
port: 50036
|
|
user: witsoftd
|
|
password_env: MYSQL_PWD_WIT
|
|
readonly: true
|
|
description: "准生产环境，只读权限，通过端口转发访问"
|
|
|
|
# 目标数据库配置（VPS - root）
|
|
targets:
|
|
- name: VPS
|
|
host: 101.34.227.188
|
|
port: 3306
|
|
user: root
|
|
password_env: MYSQL_PWD_SQL
|
|
readonly: false
|
|
description: "VPS 开发环境，root 权限"
|
|
# 禁止同步的数据库黑名单
|
|
blacklist:
|
|
- ruoyi-vue-pro
|
|
- mysql
|
|
- sys
|
|
- performance_schema
|
|
- information_schema
|
|
|
|
# 输出配置
|
|
output:
|
|
base_dir: /home/yangxuan/codes/xuan-sql/scripts
|
|
date_subdir: true
|
|
write_memory: true
|
|
memory_path: /home/yangxuan/.openclaw/workspace-sql/memory
|
|
|
|
# 执行选项
|
|
execution:
|
|
# 遇到错误时继续执行其他表
|
|
continue_on_error: true
|
|
# 单表数超过此值时需用户确认
|
|
table_count_threshold: 50
|
|
# 重试次数（连接超时等）
|
|
retry_count: 3
|
|
# 字符集（默认与源库一致）
|
|
default_charset: utf8mb4
|
|
default_collation: utf8mb4_general_ci
|