dbs_dumptabstruct - Creates file set with SQL table schemas
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.
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).
Pg
mysql
racke
racke@linuxia.de
@linuxia.de
Pass options to the dumper utility, e.g. --compatible=mysql40.
--compatible=mysql40
Prints the table dumps to standard output.
Comma-separated list of tables to dump.
Excludes any table matching the regular expression REGEXP from dumping.
Only mysql and Pg drivers are supported.
Stefan Hornburg (Racke), racke@linuxia.de
0.17
perl(1), DBIx::Easy(3)
To install DBIx::Easy, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::Easy
CPAN shell
perl -MCPAN -e shell install DBIx::Easy
For more information on module installation, please visit the detailed CPAN module installation guide.