manage_indices − A tool to manage indices on Emdros databases
manage_indices
--create [options] database-name
manage_indices --drop [options] database-name
manage_indices --help
manage_indices (-V|--version)
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.
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.
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
Written Ulrik Sandborg-Petersen (ulrikp@emdros.org).