MANAGE_INDICES

Section: User Commands (1)
Updated: January 20, 2007
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: "2", "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: 20:36:16 GMT, January 26, 2008