DBS_DUMPTABDATA(1p) User Contributed Perl Documentation DBS_DUMPTABDATA(1p)
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 appropri-
ate dumper utility with the output directed to a file named table.sql in the current directory. dbs_dumptabdata asks for a password if nec-
essary.
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)
perl v5.8.8 2007-02-01 DBS_DUMPTABDATA(1p)
