Creates file set with sql table schemas
dbs_dumptabstruct is an utility to create a file set with \s-1SQL\s0 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 \s-1DBI\s0 driver (\*(C`Pg\*(C' for Postgres or \*(C`mysql\*(C' for MySQL) and the database name. The third parameter is optionally and specifies the database user and/or the host where the database resides (\*(C`racke\*(C', \*(C`[email protected]\*(C' or \*(C`@linuxia.de\*(C').
\$1
Pass options to the dumper utility, e.g. \*(C`--compatible=mysql40\*(C'. Prints the table dumps to standard output. Comma-separated list of tables to dump. Excludes any table matching the regular expression \s-1REGEXP\s0 from dumping.
Only mysql and Pg drivers are supported.
Stefan Hornburg (Racke), [email protected]
0.17
perl\|(1), DBIx::Easy\|(3)