dbs_dumptabstruct - Creates file set with SQL table schemas
Contents
Bugs
Only mysql and Pg drivers are supported.
Command Line Options
-d=OPTIONS,-o=OPTIONS,--dump-options=OPTIONS
Pass options to the dumper utility, e.g. "--compatible=mysql40".
-p,--pipe
Prints the table dumps to standard output.
-tTABLE[,TABLE,...],--tables=TABLE[,TABLE,...]
Comma-separated list of tables to dump.
--exclude-matching-tables=REGEXP
Excludes any table matching the regular expression REGEXP from dumping.
Command Line Parameters
Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for MySQL) and the
database name. The third parameter is optionally and specifies the database user and/or the host where
the database resides ("racke", "racke@linuxia.de" or "@linuxia.de").
Description
dbs_dumptabstruct is an utility to create a file set with SQL table schemas. For each table in the
database dbs_dumptabstruct calls the appropriate dumper utility with the output directed to a file named
table.sql in the current directory. dbs_dumptabstruct asks for a password if necessary.
Name
dbs_dumptabstruct - Creates file set with SQL table schemas
See Also
perl(1), DBIx::Easy(3) perl v5.38.2 2024-03-24 DBS_DUMPTABSTRUCT(1p)
Version
0.17
