*

The output is formatted much in the same way as by the msql or mysql monitor (see below), the msqlexport command and the relshow (mysqlshow) programs, which are coming with msql or mysql.

*

The additional capability is a connection to a readline interface (if available) and a pipe to your favorite pager.

*

Additionally you may switch between hosts and databases within one session and you don't have to type the nasty "\g" or ";" (a trailing "\g", "\q", and "\p" will be ignored).

If a command starts with one of the following reserved words, it's treated specially, otherwise it is passed on verbatim to the DBMS. Output from the daemon is piped to your pager specified by either the DBIMON_PAGER or the PAGER environment variable. If both are undefined, the PATH is searched for either ``less'' or ``more'' and the first program found is taken. If no pager can be determined or your pager variable is empty or set to "stdout", the program writes to unfiltered STDOUT.

?

?

print usage summary

dsn <dsn>

dsn <dsn>

Connects to the given <dsn>, the old connection is closed.

q[uit]

q[uit]

Leave dbimon.

re[lshow] [<dsn> [<table>]]

re[lshow] [<dsn> [<table>]]

Without arguments this lists possible data sources by calling DBI's data_sources method. Data sources are driver dependent, the driver of the last connection will be used. Unfortunately DBI offers no possibilities of specifying a hostname or similar dsn attributes, so you can hardly list a remote hosts dsns, for example.

If a "dsn" is given, dbimon will connect to the given dsn and list its tables. If both "dsn" and "table" are present, dbimon will list the tables fields.

The latter possibilities are not supported by the DBI - these work with private methods. Currently they are implemented for DBD::mSQL and DBD::mysql.

se[t] [<var> [<val>]]

se[t] [<var> [<val>]]

This command displays and modifies dbimon's internal variables. Without arguments, all variables and their current settings are listed. With a variable name only you query the variables value. The two argument form modifies a variable. Supported variables are:

showMode

This variable controls the output of an SQL result table. Possible values are "Box", "Export", "List", "Table" and "HTML". These correspond to modes of the Data::ShowTable module with the exception of "Export": This is handled by dbimon internally, as Data::ShowTable doesn't offer such a mode. The "Export" mode is well suited for exporting data to other database systems. See Data::ShowTable(3).

less

This is the pager variable. You can turn off paging by setting this to 'stdout'.

listWrapMargin

maxTableWidth

noEscape

These correspond to the variables "$List_Wrap_Margin", "$Max_Table_Width" and "$No_Escape" of the Data::ShowTable module. See Data::ShowTable(3).

escapeChar

quoteChar

sepChar

For "Export" mode dbimon will use these variables. Columns are surrounded by the quoteChar, separated by the sepChar and the escapeChar is used for inserting these special characters. The defaults are well suited for Excel (escapeChar = """, quoteChar = """ and sepChar = ";"), thus a row with the values 1, 'walrus' and 'Nat ``King'' Cole' will be displayed as

  "1";"walrus";"Nat ""King"" Cole"

! EXPR

! EXPR

Eval the EXPR in perl

Dumping means to emit a

    CREATE TABLE $table (...)

    INSERT INTO $table (...)

The completion mechanism is very basic, and I'm not intending to refine it in the near future. Feel free to implement your own refinements and let me know, if you have something better than what we have here.

See the pmsql (1) entry elsewhere in this document, the DBI (3) entry elsewhere in this document, the Term::ReadKey (3) entry elsewhere in this document, the Term::ReadLine (3) entry elsewhere in this document,