Query: sql::translator::producer::dumper
OS: debian
Section: 3pm
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
SQL::Translator::Producer::Dumper(3pm) User Contributed Perl Documentation SQL::Translator::Producer::Dumper(3pm)NAMESQL::Translator::Producer::Dumper - SQL Dumper producer for SQL::TranslatorSYNOPSISuse 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 listDESCRIPTIONThis 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.AUTHORKen Youens-Clark <kclark@cpan.org>. perl v5.14.2 2012-01-18 SQL::Translator::Producer::Dumper(3pm)
Similar Topics in the Unix Linux Community |
---|
Installing Dash Shell on OS X Lion |
Introduction |
Weird 'find' results |
How to copy a column of multiple files and paste into new excel file (next to column)? |
New UNIX and Linux History Sections |