dbs_dumptabstruct(1p) debian man page | unix.com

Man Page: dbs_dumptabstruct

Operating Environment: debian

Section: 1p

DBS_DUMPTABSTRUCT(1p)					User Contributed Perl Documentation				     DBS_DUMPTABSTRUCT(1p)

NAME
dbs_dumptabstruct - Creates file set with SQL table schemas
DESCRIPTION
dbs_dumptabstruct is an utility to create a file set with SQL 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 pass- word 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
-d=OPTIONS, -o=OPTIONS, --dump-options=OPTIONS Pass options to the dumper utility, e.g. "--compatible=mysql40". -p, --pipe Prints the table dumps to standard output. -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.
BUGS
Only mysql and Pg drivers are supported.
AUTHOR
Stefan Hornburg (Racke), racke@linuxia.de
VERSION
0.17
SEE ALSO
perl(1), DBIx::Easy(3) perl v5.8.8 2007-02-01 DBS_DUMPTABSTRUCT(1p)
Related Man Pages
create_foreign_table(7) - centos
drop_table(7) - suse
cgi::session::driver::mysql(3) - centos
drop_table(7) - debian
drop_table(7) - linux
Similar Topics in the Unix Linux Community
Comma delimited file
Links replacement on sql dump
Export table and restart from last table
Linux parameters in SQL command
Call SQL LOADER FROM UNIX