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
7       SQL::Translator
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
24       suitable for MySQL's LOAD DATA command.  If you enable "add-truncate"
25       or specify tables to "skip" (also using the "skiplike" regular
26       expression) then the generated dumper script will leave out those
27       tables.  However, these will also be options in the generated dumper,
28       so you can wait to specify these options when you dump your database.
29       The database username, password, and DSN can be hardcoded into the
30       generated script, or part of the DSN can be intuited from the
31       "database" argument.
32

AUTHOR

34       Ken Youens-Clark <kclark@cpan.org>.
35
36
37
38perl v5.36.0                      2023-02-2S7QL::Translator::Producer::Dumper(3)
Impressum