MySQL-migration-tools/.mysql-client.ini.example at master · utilmind/MySQL-migration-tools · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
; MySQL / MariaDB client option file
;
; This file is intentionally kept OUT of version control (see .gitignore).
; It stores sensitive connection settings (user, password, SSL options)
; that must not be hardcoded in shared *.bat scripts.
;
; When present, this file is automatically loaded by `db-dump.bat`,
; `db-import.bat` and `dump-users-and-grants.bat` via:
;
;   --defaults-extra-file=.mysql-client.ini
;
; Notes:
; - This file is OPTIONAL. If it does not exist, the scripts fall back to
;   the default / hardcoded settings and interactive password prompt.
; - Settings defined here have HIGHER priority than values hardcoded
;   in the batch scripts.
; - Command-line options still have the highest priority and therefore
;   are intentionally minimized when this file is used.
;
; Security:
; - Restrict file permissions so only your OS user can read this file.
; - NEVER COMMIT this file to a public repository.
;   And actually even if you commit it to private repo, it should not
;   expose the real password.
;
; Structure:
; - [client]     - common connection settings (host, user, password, SSL)
; - [mysqldump]  - dump-specific options (optional)
; - [mysql]      - import-specific options (optional)
;
; You do NOT need to duplicate credentials between sections.
; MySQL clients automatically inherit shared options from [client].
;
[client]
host=127.0.0.1
port=3306
user=backup_user
password=SuperSecretPassword
default-character-set=utf8mb4

; Optional SSL settings.
ssl-ca=C:/Users/USERNAME/.ssh/rds-global-bundle.pem
; Uncomment if you would like to disable SSL (not recommended)
# ssl=0
# skip-ssl
; The following one is for MySQL only, not available in MariaDB.
# ssl-mode=REQUIRED

[mysqldump]
; Dump-specific options (optional)
max-allowed-packet=1024M
net-buffer-length=4194304
single-transaction
quick
compress
routines
events
triggers
hex-blob
no-tablespaces
;set-gtid-purged=OFF
;column-statistics=0

[mysql]
; Import-specific options (optional)
max-allowed-packet=1024M
net-buffer-length=4194304