Usage: mydbmunger [OPTIONS] COMMAND SCHEMA
Available COMMANDs are "pull", "push", and "make-archive"
pull
Connect to database and pull down current table definitions and
trigger definitions.
push
Connect to database and deploy current table definitions by creating
or modifying tables.
make-archive
Write trigger and archive table definitions.
GENERAL OPTIONS:
-d, --dryrun Don't commit any changes, just print SQL that would be
executed.
-D, --dir=PATH Directory in which to read and write database information.
Default is current directory.
-h, --host=name Connect to host.
--no-tables Don't do anything with triggers.
--no-triggers Don't do anything with triggers.
-p, --password[=PASSWORD]
Password to use when connecting to server. If password is
not provided on the command line it will asked from the
tty.
-P, --port=# Port number to use for connection or 0 for default to, in
order of preference, my.cnf, \$MYSQL_TCP_PORT,
/etc/services, built-in default (3306).
-t, --table=TABLE[,TABLE]...
Specify for which tables to perform the given COMMAND. If
not provided, then we will attempt to detect suitable
tables automatically.
-u, --user=NAME User for login if not current user.
-v, --verbose Show verbose messages.
OPTIONS FOR COMMAND pull:
--init-trigger-name=NAME
Name to use for any unlabeled trigger fragments. Without
this option, unlabeled fragments are treated as an
error.
OPTIONS FOR COMMAND make-archive:
--actioncol=COLUMN
Column name used in archive table to store the SQL
type of SQL action caused the archive to be created.
Default: "action"
--ctime[=COLUMN]
Column name used in the source data and archive tables
used to track record creation time. This must be a
TIMESTAMP or DATETIME data type. If option this option
is given without a vaulue then the column name "ctime"
will be used. Default is no creation time handling.
--dbusercol=COLUMN
Column name to be used in archive table to store the
database connection login information. Default: "user"
--archive-name-pattern=s
How to name archive tables. Specified as a pattern with
a placeholder "%" for the original table name. Default:
"%Archive", so by a table named "Post" would have a
archive table named "PostArchive".
--mtime[=COLUMN]
Column name used in the source data and archive tables
used to track last-modification time. This must be a
TIMESTAMP or DATETIME data type. If option this option
is given without a vaulue then the column name "mtime"
will be used. Default is no modification time handling.
--revision=COLUMN
Column name used in the source data and archive tables
to track revision count. Default: "revision"
--stmtcol=COLUMN
Column name used in the archive table to record the SQL
query that initiated the table change.
--updidcol=COLUMN
Column name used in archive table to store the
application user retrieved from the value of the
variable named by option --updidvar. Default: "\@updid"
--updidvar=VARNAME
Variable name used to store an application user and to
store in the column designated by --updidcol.