MANAGE_INDICES
Section: User Commands (1)
Updated: September 23, 2006
Index
Return to Main Contents
NAME
manage_indices - A tool to manage indices on Emdros databases
SYNOPSIS
manage_indices --create [options] database-name
manage_indices --drop [options] database-name
manage_indices --help
manage_indices (-V|--version)
DESCRIPTION
manage_indices is a tool for creating and dropping indices on an
Emdros database's object types. If the option "--type
object-type-name" is given, only that object type is affected. If
this option is not given, all object types in the database are
affected.
OPTIONS
manage_indices supports the following command-line switches:
- --help
-
show help
- -V , --version
-
show version
- --create
-
indices are created
- --drop
-
indices are dropped
- -b , --backend backend
-
-
set database backend to `backend'. Valid values are: For PostgreSQL:
"p", "pg", "postgres", and "postgresql". For MySQL: "m", "my", and
"mysql". For SQLite 2.X.X: "s", "l", "lt", "sqlite", and
"sqlite2". For SQLite 3.X.X: "3", "s3", "lt3", and "sqlite3".
-t , --type object-type-name
only the object type object-type-name is affected
- -h , --host hostname
-
set db back-end hostname to connect to (default is 'localhost'). Has
no effect on SQLite.
- -u , --user user
-
set database user to connect as (default is 'emdf'). Has no effect on
SQLite.
- -p , --password password
-
set password to use for the database user. Has no effect on SQLite,
unless you have an encryption-enabled SQLite, in which case this gets
passed as the key.
RETURN VALUES
- 0 Success
-
- 1 Wrong usage
-
- 2 Connection to backend server could not be established
-
- 3 An exception occurred (the type is printed on stderr)
-
- 5 Database error
-
AUTHORS
Copyright
2001-2006 by Ulrik Petersen (ulrikp@users.sourceforge.net). Note that
this software is distributed under the GNU GPL. See the sources for
details.
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- OPTIONS
-
- RETURN VALUES
-
- AUTHORS
-
This document was created by
man2html,
using the manual pages.
Time: 22:29:32 GMT, December 01, 2006