Data dumper   msqldump

Usage

msqldump [ h host] [ f confFile] [ c] [ v] database [table]

Options

 h

Specify a remore hostname or IP address on which the mSQL server is running. The

default is to connect to a server on the localhost using a UNIX domain socket rather than

TCP/IP (which gives better performance)

 f

Specify a non default configuration file to be loaded. The default action is to load the the

standard configuration file located in INST_DIR/msql.conf (usually

/usr/local/Hughes/msql.conf)

 c

Include column names in INSERT commands generated by the dump.

 v

Run in verbose mode. This will display details such as connection results etc.

Description

msqldump produces an ASCII text file containing valid SQL commands that will recreate the

table or database dumped when piped through the mSQL monitor program. The output will

include all CREATE TABLE commands required to recreate the table structures, CREATE

INDEX commands to recreate the indices, and INSERT commands to populate the tables with

the data currently contained in the tables.

Note

G   

 : msqldump does not recreate sequences at this time.

Data exporter   msqlexport

Usage

msqlexport [ h host] [ f conf] [ v] [ s Char] [ q Char] [ e Char] database table

Options

 h

Specify a remore hostname or IP address on which the mSQL server is running. The

default is to connect to a server on the localhost using a UNIX domain socket rather than

TCP/IP (which gives better performance)

 f

Specify a non default configuration file to be loaded. The default action is to load the the

standard configuration file located in INST_DIR/msql.conf (usually

/usr/local/Hughes/msql.conf)

 v

Verbose mode

 s

Use the character Char as the separation character. The default is a comma.

 q

Quote each value with the specified character

 e

Use the specifed Char as the escape character. The default is \

Description

msqlexport produces an ASCII export of the data from the specified table. The output

produced can be used as input to other programs such as spreadsheets. It has been designed to

be as flexible as possible allowing the user to specify the character to use to separate the fields,

the character to use to escape the separator character if it appears in the data, and whether the

data should be quoted and if so what character to use as the quote character.

The output is sent to stdout with one data row per line.

G   

Data importer   msqlimport

Usage

msqlimport [ h host] [ f conf] [ v] [ s Char] [ e Char] [ c col,col...] database table