Content-type: text/html
Man page of BOOTS
BOOTS
Section: Drizzle Database System (1)
Updated: 2010-03-07
Index
Return to Main Contents
NAME
boots - the Boots command-line tool
SYNOPSIS
boots [OPTION]
DESCRIPTION
Boots is an SQL shell which provides a command line interface to relational database servers. When used interactively it presents query results in an ASCII-table format. When used non-interactively it presents results in a tab-separated format.
OPTIONS
- -c, --command
-
Execute a command and exit.
- -D, --database
-
Indicate the database to use.
- -f, --script
-
Execute commands from a file and exit.
- -F, --historyfile
-
Save history to specified file.
- -?, --help
-
Display boots client help information and exit.
- -H=host_name, --host host_name
-
Connect to the Drizzle server on the given host.
- -l, --lingo
-
Set the lingo to use.
- -L, --historylength
-
Specify maximum history file length.
- -X, --norc
-
Do not read user configuration file.
- -r, --rc
-
Filename of user configuration file.
- -p=port_num, --port port_num
-
The TCP/IP to use to connect to the drizzled server.
- -P, --password
-
Connect using the password. If none is given, query for the password.
- -t, --terminatingchar
-
Specify the SQL statement terminating character. The default is ';'.
- -u, --user
-
Login with user name.
EXAMPLES
Connecting to a Drizzle Server
To connect to the database ``test'' in a Drizzle server running on localhost
and listening on port 9306:
boots --host=localhost --port=9306 -D test
Executing SQL commands in a File
To connect to the Drizzle server in the previous example, running SQL commands
from a file ``./myscript'':
boots --host=localhost --port=9306 -D test -f ./myscript
EXIT STATUS
When exited normally Drizzle will exit with a return code of 0.
FILES
~/.bootsrc
~/.boots_history
REPORTING BUGS
Bugs should be reported at https://bugs.launchpad.net/boots/+filebug
NOTES
Boots is still alpha code. Please don't depend upon it in production.
COPYRIGHT
Boots is Copyright (C) 2009-2010 by Clark Boylan, Ken Brotherton, Max Goodman,
Victoria Lewis, David Rosenbaum, and Andreas Turriff.
SEE ALSO
bootsrc(5)
You can sign up to the project mailing list at https://launchpad.net/~boots-discuss
For more information please see https://launchpad.net/boots/
AUTHORS
Clark Boylan (cboylan@cs.pdx.edu),
Ken Brotherton (broken@cs.pdx.edu),
Max Goodman (mgood@cs.pdx.edu),
Victoria Lewis (victor@cs.pdx.edu),
David Rosenbaum (drosenba@cs.pdx.edu), and
Andreas Turriff (aturriff@cs.pdx.edu).
Much of the content in this manpage has been adopted from the original drizzle
manpage written by Sun Microsystems, Inc.
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- OPTIONS
-
- EXAMPLES
-
- Connecting to a Drizzle Server
-
- Executing SQL commands in a File
-
- EXIT STATUS
-
- FILES
-
- REPORTING BUGS
-
- NOTES
-
- COPYRIGHT
-
- SEE ALSO
-
- AUTHORS
-
This document was created by
man2html,
using the manual pages.
Time: 11:32:40 GMT, March 07, 2010