db_cmd

SYNOPSIS

db_cmd.pl {-url <url> | [-reg_conf <reg_conf>] -reg_alias <reg_alias> [-reg_type <reg_type>] } [ -exec <alt_executable> ] [ -prepend <prepend_params> ] [ -sql <sql_command> ] [ -verbose ] [other arguments to append to the command line]

DESCRIPTION

db_cmd.pl is a generic script that connects you interactively to your database using either URL or Registry and optionally runs an SQL command.

OPTIONS

--url <url> URL defining where eHive database is located
--reg_conf <path>
 path to a Registry configuration file
--reg_alias <str>
 species/alias name for the eHive DBAdaptor
--executable <name|path>
 The executable to run instead of the driver’s default (which is the command-line client)
--prepend <string>
 Argument that has to be prepended to the connection details. This option can be repeated
--sql <string> SQL command to execute
--verbose Print the command before running it.
--help Print this help message

All the remaining arguments are passed on to the command to be run. If some of them start with a dash, first use a double-dash to indicate the end of db_cmd.pl’s options and the start of the arguments that have to be passed as is (see the example below with –html)

USAGE EXAMPLES

db_cmd.pl -url "mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/" -sql 'CREATE DATABASE lg4_long_mult'
db_cmd.pl -url "mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/lg4_long_mult"
db_cmd.pl -url "mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/lg4_long_mult" -sql 'SELECT * FROM analysis_base' -- --html
db_cmd.pl -url "mysql://ensadmin:${ENSADMIN_PSW}@localhost/lg4_long_mult" -exec mysqldump -prepend -t analysis_base job

db_cmd.pl -reg_conf ${ENSEMBL_CVS_ROOT_DIR}/ensembl-compara/scripts/pipeline/production_reg_conf.pl -reg_alias compara_master
db_cmd.pl -reg_conf ${ENSEMBL_CVS_ROOT_DIR}/ensembl-compara/scripts/pipeline/production_reg_conf.pl -reg_alias mus_musculus   -reg_type core
db_cmd.pl -reg_conf ${ENSEMBL_CVS_ROOT_DIR}/ensembl-compara/scripts/pipeline/production_reg_conf.pl -reg_alias squirrel       -reg_type core -sql 'SELECT * FROM coord_system'