MQLDUMP
Section: User Commands (1)
Updated: September 23, 2006
Index
Return to Main Contents
NAME
mqldump - A tool to dump Emdros databases in MQL
SYNOPSIS
mqldump [ options ] database [object type names...]
DESCRIPTION
mqldump is a tool to dump (parts of) an Emdros database into an
MQL script. This MQL script can then later be run through the
mql(1) program to recreate (the dumped parts of) the database.
If one or more object type names are given after the database name,
only those object types are processed in the order given. Otherwise,
all object types are processed.
If the -o option is given, the output is placed on the file with the
filename given. Otherwise, the output is dumped to stdout.
Object id_ds are preserved, i.e., when dumping object data, each
CREATE OBJECT statement has a WITH ID_D part. This makes it possible
to import the MQL script again and preserve things like id_d feature
values that point to other objects.
If the -v or --verbose option is given, a lot of information is
displayed showing the progress of the dump. When dumping objects,
each emitted dot represents 5000 objects.
OPTIONS
mqldump supports the following command-line switches:
- --help
-
show help
- -V , --version
-
show version
- -b , --backend backend
-
set database backend to `backend'. Valid values are: For PostgreSQL:
"p", "pg", "postgres", and "postgresql". For MySQL: "m", "my", and
"mysql". For SQLite 2.X.X: "s", "l", "lt", "sqlite", and
"sqlite2". For SQLite 3.X.X: "3", "s3", "lt3", and "sqlite3".
- -h , --host hostname
-
set db back-end hostname to connect to (default is 'localhost'). Has
no effect on SQLite.
- -u , --user user
-
set database user to connect as (default is 'emdf'). Has no effect on
SQLite.
- -p , --password password
-
set password to use for the database user. Has no effect on SQLite,
unless you have an encryption-enabled SQLite, in which case this gets
passed as the key.
- -v , --verbose
-
be verbose
- -o filename
-
produce output on file rather than stdout
- -n , --no-create-db
-
do not produce CREATE DATABASE and USE DATABASE statements at the beginning
- -i , --no-create-info
-
do not produce meta-data info (same as --no-create-enums
--no-create-object-types)
- -t , --no-create-object-types
-
do not produce object type meta-data info (i.e., don't produce CREATE
OBJECT TYPE statements)
- -e , --no-create-enums
-
do not produce enumeration (meta-)data info (i.e., don't create
enumerations and enumeration constants by producing CREATE ENUMERATION
statements)
- -m , --no-create-monad-sets
-
do not produce arbitrary monad sets (i.e., don't create monad sets by
producing CREATE MONAD SET statements)
- -d , --no-create-objects
-
do not produce object data (i.e., don't produce CREATE OBJECT statements)
- --batch-create-objects
-
use CREATE OBJECTS WITH OBJECT TYPE rather than individual CREATE
OBJECT statements.
- --batch-size number
-
issue number object-creations per CREATE OBJECTS WITH OBJECT
TYPE statement. Implies --batch-create-objects.
- --start number
-
set monad at which dumping should start. Default is MIN_M (i.e.,
lowest monad in database).
- --end number
-
set monad at which dumping should end. Default is MAX_M (i.e.,
highest monad in database).
RETURN VALUES
- 0 Success
-
- 1 Wrong usage
-
- 2 Connection to backend server could not be established
-
- 3 An exception occurred (the type is printed on stderr)
-
- 4 Could not open file
-
- 5 Database error
-
- 6 Compiler error (error in MQL input)
-
AVAILABILITY
Available from http://emdros.org/.
AUTHORS
Copyright
2003-2006 by Ulrik Petersen (ulrikp@users.sourceforge.net). Note that
this software is distributed under the GNU GPL. See the sources for
details.
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- OPTIONS
-
- RETURN VALUES
-
- AVAILABILITY
-
- AUTHORS
-
This document was created by
man2html,
using the manual pages.
Time: 22:29:32 GMT, December 01, 2006