Usage: skeema add-environment [<options>] <environment>
Modifies the .skeema file in an existing host directory to add a new named environment. For example, if skeema init was previously used to create a dir for a host with the default “production” environment, skeema add-environment could be used to define a “staging” or “development” environment pointing at a different host and port, or perhaps a “local” environment pointing at localhost and a socket path.
This command currently only handles very simple cases. For many situations, editing .skeema files directly is a better approach.
Add-Environment Options
| Option | Description |
|---|---|
| dir | Base dir for this host’s schemas |
| host | Database hostname or IP address |
| port | Port to use for database host |
| socket | Absolute path to Unix socket file used if host is localhost |
Global Options
| Option | Description |
|---|---|
| connect-options | Comma-separated session options to set upon connecting to each database server |
| debug | Enable debug logging |
| help | Display usage information for the specified command |
| host-wrapper | External bin to shell out to for host lookup; see manual for template vars |
| ignore-event | Ignore events that match regex |
| ignore-func | Ignore functions that match regex |
| ignore-proc | Ignore stored procedures that match regex |
| ignore-schema | Ignore schemas that match regex |
| ignore-table | Ignore tables or views that match regex |
| ignore-trigger | Ignore triggers that match regex |
| ignore-view | Ignore views that match regex |
| my-cnf | Parse ~/.my.cnf for configuration (enabled by default; disable with skip-my-cnf) |
| password | Password for database user; omit value to prompt from TTY |
| server-public-key-path | File path to server public key in PEM format; omit to obtain from server |
| ssh | Tunnel MySQL connections thru SSH to this hostname or user@hostname:port |
| ssh-to-db | SSH to database host in order to establish database connections locally |
| ssl-ca | File path to certificate authority in PEM format |
| ssl-cert | File path to client-side public key in PEM format |
| ssl-key | File path to client-side private key in PEM format |
| ssl-mode | Specify desired connection security SSL/TLS usage |
| ssl-verify-server-cert | Verify server-side cert matches server hostname |
| user | Username to connect to database host |
| version | Display program version |