|
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 |
- |
|
|