SQL::Translator::Producer::Dumper - SQL Dumper producer for SQL::Translator

       Ken Youens-Clark <kclark@cpan.org>.

perl v5.40.0                                       2024-11-23             SQL::Translator::Producer::Dumper(3pm)

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

       SQL::Translator::Producer::Dumper - SQL Dumper producer for SQL::Translator

         use SQL::Translator::Producer::Dumper;

         Options:

           db_user         Database username
           db_password     Database password
           dsn             DSN for DBI
           mysql_loadfile  Create MySQL's LOAD FILE syntax instead of INSERTs
           skip=t1[,t2]    Skip tables in comma-separated list
           skiplike=regex  Skip tables in comma-separated list