MSQL(1)

NAME
msqladmin - Mini SQL Database Administration

SYNOPSIS
msqladmin [ -h host ] command database

DESCRIPTION
Databases are administered using the msqladmin command. Several administrative tasks, such as creating new databases and forcing a server shutdown are performed using msqladmin. See libmsql(3) for Details in specifying a hostname. The msqladmin command must be run as mSQL root user (e.g. as user msql) on the database server. An attempt to perfom any of these commands from a remote client or as a non-root user will result in a ``permission denied'' error. The only exception to this is the version command.

COMMANDS
msqladmin does not work interactively, instead all commands must be specified on the commandline. The following commands are available

create database
    Create a new database with the given name.

drop database
    Delete the entire database called database. If the database still contains data you are queried if you really want to remove it.

shutdown
    Tell the server to shut itself down.

reload
    Tell the server to reload the access control file. Before submitting the file to the engine it is syntactically checked. Due to special information that are carried inside of this file, but not handled by the database engine you might need to /etc/init.d/msql restart the server.

version
    Display various verson information from the server. We warned, not all displayed information are queried from the server but guessed instead.

ENVIRONMENT
The mSQL program 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
    Specifies debuging. See libmsql(3) for possible values.

VISUAL, EDITOR
    If the query shall be edited you may specify your favourite editor here.

FILES

/etc/msql.acl
    Access control information for all databases.

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.

SEE ALSO
msql.acl(5), libmsql(3), msqld(8).