dbs_dumptabdata(1p)

dbs_dumptabdata1p

Creates file set with sql table data

Overview

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", "[email protected]" or "@linuxia.de").

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.

Releases

13 releases since Debian 2.2 (Potato); the text changed 7 times.

  1. 2.2
  2. 3.0
  3. 3.1
  4. 4.0
  5. 5.0–8
  6. 9–10
  7. 11–12
  8. 13

Bugs

msql is not supported.

Author

Stefan Hornburg (Racke), [email protected]

From libdbix-easy-perl 0.21-1.2 in Debian 13 (Trixie). Parsed by carta from the page's man source.