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