Schema viewer   relshow

Usage

relshow [ h host] [ f confFile] [database [rel [idx] ] ]

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)

Description

Relshow is used to display the structure of the contents of mSQL databases. If no arguments

are given, relshow will list the names of the databases currently defined. If a database name is

given it will list the tables defined in that database. If a table name is also given then it will

display the structure of the table (i.e. field names, types, lengths etc).

If an index name is provided along with the database and table names, relshow will

G   

display the structure of the specified index including the type of index and the fields

that comprise the index.

Admin program   msqladmin

Usage

msqladmin [ h host] [ f confFile] [ q] Command

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)

 q

Put msqladmin into quiet mode. If this flag is specified, msqladmin will not prompt

the user to verify dangerous actions (such as dropping a database).

Description

msqladmin is used to perform administrative operations on an mSQL database server. Such

tasks include the creation of databases, performing server shutdowns etc. The available

commands for msqladmin are

create

Creates a new database called db_name

db_name

drop

Removes the database called db_name from the server. This will also delete all

db_name

data contained in the database!

shutdown Terminates the mSQL server.

reload

Forces the server to reload ACL information.

version

Displays version and configuration information about the currently running server.

stats

Displays server statistics.

Note

G   

 : most administrative functions can only be executed by the user specified in the

run time configuration as the admin user. They can also only be executed from the host

on which the server process is running (e.g. you cannot shutdown a remote server

process).