View | Details | Raw Unified | Return to bug 12372
Collapse All | Expand All

(-)a/debian/docs/koha-mysql.xml (-6 / +18 lines)
Lines 17-42 Link Here
17
17
18
  <refnamediv>
18
  <refnamediv>
19
    <refname>koha-mysql</refname>
19
    <refname>koha-mysql</refname>
20
    <refpurpose>Provide an interactive mysql shell set up for the specified Koha instance.</refpurpose>
20
    <refpurpose>Provide a mysql shell set up for the specified Koha instance.</refpurpose>
21
    <refclass>UNIX/Linux</refclass>
21
    <refclass>UNIX/Linux</refclass>
22
  </refnamediv>
22
  </refnamediv>
23
23
24
  <refsynopsisdiv>
24
  <refsynopsisdiv>
25
    <cmdsynopsis>
25
    <cmdsynopsis>
26
      <command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg>
26
      <command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> <arg choice="opt" rep="repeat">mysql option</arg>
27
    </cmdsynopsis>
27
    </cmdsynopsis>
28
  </refsynopsisdiv>
28
  </refsynopsisdiv>
29
29
30
  <refsect1><title>Description</title>
30
  <refsect1><title>Description</title>
31
  <para>Provide an interactive mysql shell set up for the specified Koha instance.</para>
31
  <para>Provide a mysql shell set up for the specified Koha instance.</para>
32
  </refsect1>
32
  </refsect1>
33
33
34
  <refsect1><title>Example usage</title>
34
  <refsect1><title>Example usage</title>
35
    <variablelist>
35
    <variablelist>
36
      <varlistentry>
36
      <varlistentry>
37
        <term>Send an SQL query to MySQL</term>
37
        <term>Run interactive mysql shell for speicified Koha instance</term>
38
        <listitem>
38
        <listitem>
39
          <para>"Some SQL query" | <command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg></para>
39
          <para><command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg></para>
40
        </listitem>
41
      </varlistentry>
42
      <varlistentry>
43
        <term>Run a query given as an argument without launching mysql shell</term>
44
        <listitem>
45
          <para><command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> -e "SOME SQL QUERY"</para>
46
        </listitem>
47
      </varlistentry>
48
      <varlistentry>
49
        <term>Run a query, skip column names on output</term>
50
        <listitem>
51
          <para><command>koha-mysql</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> -e "SOME SQL QUERY" --skip-column-names</para>
40
        </listitem>
52
        </listitem>
41
      </varlistentry>
53
      </varlistentry>
42
      <varlistentry>
54
      <varlistentry>
Lines 50-55 Link Here
50
  
62
  
51
  <refsect1><title>See also</title>
63
  <refsect1><title>See also</title>
52
  <simplelist type="inline">
64
  <simplelist type="inline">
65
    <member><command>mysql (1)</command></member>
53
    <member><command>koha-dump-defaults(8)</command></member>
66
    <member><command>koha-dump-defaults(8)</command></member>
54
    <member><command>koha-reset-passwd(8)</command></member>
67
    <member><command>koha-reset-passwd(8)</command></member>
55
    <member><command>koha-upgrade-schema(8)</command></member>
68
    <member><command>koha-upgrade-schema(8)</command></member>
56
- 

Return to bug 12372