NAME¶
dbs_dumptabdata - Creates file set with SQL table data
DESCRIPTION¶
dbs_dumptabdata is an utility to create a file set with SQL table data. For each
table in the database dbs_dumptabdata calls the appropriate dumper utility
with the output directed to a file named
table.sql in the current
directory. dbs_dumptabdata asks for a password if necessary.
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").
COMMAND LINE OPTIONS¶
-t TABLE[,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.
--use-printtab
Uses generic dump (similar to "dbs_printtab") instead of the dumper
utility provided by the DBMS.
BUGS¶
msql is not supported.
AUTHOR¶
Stefan Hornburg (Racke), racke@linuxia.de
SEE ALSO¶
perl(1),
DBIx::Easy(3)