Stefan Hornburg (Racke) > DBIx-Easy-0.21 > dbs_dumptabdata

Download:
DBIx-Easy-0.21.tar.gz

Annotate this POD

View/Report Bugs
Source  

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)

syntax highlighting: