Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
SQL::Translator::ProduUser:Contributed PerSQL::Translator::Producer::Dumper(3)

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

SYNOPSIS
	 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

DESCRIPTION
       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.

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

perl v5.32.0			  2020-04-SQL::Translator::Producer::Dumper(3)

NAME | SYNOPSIS | DESCRIPTION | AUTHOR

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=SQL::Translator::Producer::Dumper&sektion=3&manpath=FreeBSD+12.2-RELEASE+and+Ports>

home | help