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