db_cmd.html 3.33 KB
Newer Older
Matthieu Muffato's avatar
Matthieu Muffato committed
1 2 3 4 5 6
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>db_cmd.pl</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
7
<link rev="made" href="mailto:root@localhost" />
Matthieu Muffato's avatar
Matthieu Muffato committed
8 9
</head>

10
<body>
Matthieu Muffato's avatar
Matthieu Muffato committed
11 12


13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

<h1 id="NAME">NAME</h1>

<pre><code>    db_cmd.pl</code></pre>

<h1 id="SYNOPSIS">SYNOPSIS</h1>

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

<h1 id="DESCRIPTION">DESCRIPTION</h1>

<pre><code>    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.
    -url is exclusive to -reg_alias. -reg_type is only needed if several databases map to that alias / species.
    If the arguments that have to be appended contain options (i.e. start with dashes), first use a double-dash to indicate the end of db_cmd.pl&#39;s options and the start of the arguments that have to be passed as-is (see the example below with --html)</code></pre>

<h1 id="USAGE-EXAMPLES">USAGE EXAMPLES</h1>

<pre><code>    db_cmd.pl -url &quot;mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/&quot; -sql &#39;CREATE DATABASE lg4_long_mult&#39;
Matthieu Muffato's avatar
Matthieu Muffato committed
31
    db_cmd.pl -url &quot;mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/lg4_long_mult&quot;
32 33 34
    db_cmd.pl -url &quot;mysql://ensadmin:${ENSADMIN_PSW}@localhost:3306/lg4_long_mult&quot; -sql &#39;SELECT * FROM analysis_base&#39; -- --html
    db_cmd.pl -url &quot;mysql://ensadmin:${ENSADMIN_PSW}@localhost/lg4_long_mult&quot; -exec mysqldump -prepend -t analysis_base job

Matthieu Muffato's avatar
Matthieu Muffato committed
35 36
    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
37 38 39 40
    db_cmd.pl -reg_conf ${ENSEMBL_CVS_ROOT_DIR}/ensembl-compara/scripts/pipeline/production_reg_conf.pl -reg_alias squirrel       -reg_type core -sql &#39;SELECT * FROM coord_system&#39;</code></pre>

<h1 id="LICENSE">LICENSE</h1>

41
<pre><code>    Copyright [1999-2015] Wellcome Trust Sanger Institute and the EMBL-European Bioinformatics Institute
42
    Copyright [2016-2020] EMBL-European Bioinformatics Institute
43

Matthieu Muffato's avatar
Matthieu Muffato committed
44
    Licensed under the Apache License, Version 2.0 (the &quot;License&quot;); you may not use this file except in compliance with the License.
45 46 47 48
    You may obtain a copy of the License at

         http://www.apache.org/licenses/LICENSE-2.0

Matthieu Muffato's avatar
Matthieu Muffato committed
49 50
    Unless required by applicable law or agreed to in writing, software distributed under the License
    is distributed on an &quot;AS IS&quot; BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
51 52 53 54 55 56
    See the License for the specific language governing permissions and limitations under the License.</code></pre>

<h1 id="CONTACT">CONTACT</h1>

<pre><code>    Please subscribe to the Hive mailing list:  http://listserver.ebi.ac.uk/mailman/listinfo/ehive-users  to discuss Hive-related questions or to be notified of our updates</code></pre>

Matthieu Muffato's avatar
Matthieu Muffato committed
57 58 59 60

</body>

</html>
61 62