MSQLDUMP(1)

NAME
msqldump - Mini SQL Database Dumper

SYNOPSIS
msqldump [ -c ] [ -d ] [ -h host ] [ -t ] [ -v ] [ database table ]

DESCRIPTION
The msqldump command dumps a whole mSQL database in a way it can be easily re-inserted. The mSQL database might run on a different host. Each table of a database is separated in single INSERT statements. Using this command you have an easy way to make nightly backups of your databases. All you have to do to insert a dump is to pipe it through msql(1). Such a dump consists of two parts: table creation information and data insertion information. Both of them may be suppressed, see options.

OPTIONS
The msqldump command understands the following options:

-c  Produces complete INSERT statements including all field names.

-d  Suppress data insertion information.

-h host
    Specifies a different host than localhost. See libmsql(3) for Details in specifying a hostname.

-t  Suppress table creation information.

-v  Be verbose, i.e. write additional information to stderr.

ENVIRONMENT
The mSQL family may be controlled by some environment variables. They override compiled-in default values but may be overridden by commandline arguments.

MSQL_TCP_PORT
    Specifies the TCP port on which the database engine listen to requests.

MSQL_UNIX_PORT
    Specifies the unix domain socket that shall be used to contact the engine if it runs on the local host.

MINERVA_DEBUG
    Specify debuging. See msqld(8) for possible values.

AUTHOR
Mini SQL has been written by David Hughes of Bond University, Australia as part of the Minerva Network Management Environment. He may be reached via electronic mail using bambi@Bond.edu.au. Original version of this program is written by Igor Romanenko (igor@frog.kiev.ua) under the name of msqlsave.c and placed in the public domain. This program remains in the public domain to continue the spirit of its original author although the modifications made to the original program are

SEE ALSO
msql(1), libmsql(3), msqld(8).