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

FreeBSD Manual Pages

  
 
  

home | help
MSQLDUMP(1)		    General Commands Manual		   MSQLDUMP(1)

NAME
       msqldump	- dump a MonetDB/SQL database

SYNOPSIS
       msqldump	[ options ] [ dbname ]

DESCRIPTION
       MonetDB	is a database management system	that is	developed from a main-
       memory perspective with use of a	fully decomposed storage model,	 auto-
       matic index management, extensibility of	data types and search acceler-
       ators, SQL- and XML- frontends.

       Msqldump	is the program to dump an MonetDB/SQL database.	 The dump  can
       be used to populate a new MonetDB/SQL database.

OPTIONS
       --help (-?)
	      Print usage information and exit.

       --database=database (-d database)
	      Specify  the  name of the	database to connect to.	 The -d	can be
	      omitted if it is the last	option.

       --host=hostname (-h hostname)
	      Specify the name of the host on which the	server runs  (default:
	      localhost).

       --port=portnr (-p portnr)
	      Specify the portnumber of	the server (default: 50000).

       --user=user (-u user)
	      Specify  the  user  to  connect as.  If this flag	is absent, the
	      client will ask for a user name.	Note that user must follow im-
	      mediately	after the option.

       --describe (-D)
	      Only dump	the database schema.

       --inserts (-N)
	      When  dumping the	table data, use	INSERT INTO statements,	rather
	      than COPY	INTO + CSV values.  INSERT INTO	statements are	better
	      portable,	 and  necessary	when the load of the dump is processed
	      by e.g. a	JDBC application.

       --functions (-f)
	      Only dump	functions definitions.

       --table=table (-t table)
	      Only dump	the specified table.

       --quiet (-q)
	      Don't print the welcome message.

       --Xdebug	(-X)
	      Trace network interaction	between	mclient	and the	server.

SEE ALSO
       mclient(1)

				    MonetDB			   MSQLDUMP(1)

NAME | SYNOPSIS | DESCRIPTION | OPTIONS | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=msqldump&sektion=1&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help