1SQL::Translator::ProducUesre:r:DCuomnpterri(b3u)ted PerlSQDLo:c:uTmreanntsaltaitoonr::Producer::Dumper(3)
2
3
4

NAME

6       SQL::Translator::Producer::Dumper - SQL Dumper producer for SQL::Trans‐
7       lator
8

SYNOPSIS

10         use SQL::Translator::Producer::Dumper;
11
12         Options:
13
14           db_user         Database username
15           db_password     Database password
16           dsn             DSN for DBI
17           mysql_loadfile  Create MySQL's LOAD FILE syntax instead of INSERTs
18           skip=t1[,t2]    Skip tables in comma-separated list
19           skiplike=regex  Skip tables in comma-separated list
20

DESCRIPTION

22       This producer creates a Perl script that can connect to a database and
23       dump the data as INSERT statements (a la mysqldump) or as a file suit‐
24       able for MySQL's LOAD DATA command.  If you enable "add-truncate" or
25       specify tables to "skip" (also using the "skiplike" regular expression)
26       then the generated dumper script will leave out those tables.  However,
27       these will also be options in the generated dumper, so you can wait to
28       specify these options when you dump your database.  The database user‐
29       name, password, and DSN can be hardcoded into the generated script, or
30       part of the DSN can be intuited from the "database" argument.
31

AUTHOR

33       Ken Youens-Clark <kclark@cpan.org>.
34
35
36
37perl v5.8.8                       2007-10-2S4QL::Translator::Producer::Dumper(3)
Impressum