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

(-)a/debian/docs/koha-common.xml (+8 lines)
Lines 113-118 Link Here
113
        </listitem>
113
        </listitem>
114
      </varlistentry>
114
      </varlistentry>
115
    </variablelist>
115
    </variablelist>
116
117
      <varlistentry>
118
        <term><option>koha-mysqldump</option></term>
119
        <listitem>
120
          <para>A wrapper for mysqldump for the specified koha instance.</para>
121
        </listitem>
122
      </varlistentry>
123
    </variablelist>
116
    </refsect2>
124
    </refsect2>
117
125
118
    <refsect2><title>Zebra-related</title>
126
    <refsect2><title>Zebra-related</title>
(-)a/debian/docs/koha-mysql.xml (+1 lines)
Lines 63-68 Link Here
63
  <refsect1><title>See also</title>
63
  <refsect1><title>See also</title>
64
  <simplelist type="inline">
64
  <simplelist type="inline">
65
    <member><command>mysql (1)</command></member>
65
    <member><command>mysql (1)</command></member>
66
    <member><command>koha-mysqlsump (1)</command></member>
66
    <member><command>koha-dump-defaults(8)</command></member>
67
    <member><command>koha-dump-defaults(8)</command></member>
67
    <member><command>koha-reset-passwd(8)</command></member>
68
    <member><command>koha-reset-passwd(8)</command></member>
68
    <member><command>koha-upgrade-schema(8)</command></member>
69
    <member><command>koha-upgrade-schema(8)</command></member>
(-)a/debian/docs/koha-mysqldump.xml (+63 lines)
Line 0 Link Here
1
<article xmlns='http://docbook.org/ns/docbook'>
2
<title>koha-mysqldump</title>
3
<info>
4
<productname>Koha</productname> is the first free software library automation package.
5
<author>
6
  <orgname>The Koha Community</orgname>
7
  <uri>http://koha-community.org/</uri>
8
</author>
9
</info>
10
11
<refentry xml:id="koha-mysqldump">
12
13
  <refmeta>
14
    <refentrytitle>koha-mysqldump</refentrytitle>
15
    <manvolnum>8</manvolnum>
16
  </refmeta>
17
18
  <refnamediv>
19
    <refname>koha-mysqldump</refname>
20
    <refpurpose>Provide a flexible database dumper for the specified koha instance.</refpurpose>
21
    <refclass>UNIX/Linux</refclass>
22
  </refnamediv>
23
24
  <refsynopsisdiv>
25
    <cmdsynopsis>
26
      <command>koha-mysqldump</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> <arg choice="opt" rep="repeat">mysqldump option</arg>
27
    </cmdsynopsis>
28
  </refsynopsisdiv>
29
30
  <refsect1><title>Description</title>
31
  <para>A wrapper for mysqldump for the specified koha instance.</para>
32
  </refsect1>
33
34
  <refsect1><title>Example usage</title>
35
    <variablelist>
36
      <varlistentry>
37
        <term>Dump the database associated with a given instance. SQL output goes to STDOUT.</term>
38
        <listitem>
39
          <para><command>koha-mysqldump</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg></para>
40
        </listitem>
41
      </varlistentry>
42
      <varlistentry>
43
        <term>Dump data from TABLENAME matching the where clause, redirect output to a file</term>
44
        <listitem>
45
          <para><command>koha-mysqldump</command> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg> TABLENAME --where "SOME SQL QUERY" &lt; TABLENAME.sql</para>
46
        </listitem>
47
      </varlistentry>
48
    </variablelist>
49
  </refsect1>
50
51
  <refsect1><title>See also</title>
52
  <simplelist type="inline">
53
    <member><command>mysqldump (1)</command></member>
54
    <member><command>koha-mysql (1)</command></member>
55
    <member><command>koha-dump-defaults(8)</command></member>
56
    <member><command>koha-reset-passwd(8)</command></member>
57
    <member><command>koha-upgrade-schema(8)</command></member>
58
  </simplelist>
59
  </refsect1>
60
61
</refentry>
62
63
</article>
(-)a/debian/koha-common.bash-completion (-1 / +2 lines)
Lines 135-142 complete -F _koha_enabled_instances koha-start-zebra Link Here
135
complete -F _koha_enabled_instances koha-restart-zebra
135
complete -F _koha_enabled_instances koha-restart-zebra
136
complete -F _koha_enabled_instances koha-stop-zebra
136
complete -F _koha_enabled_instances koha-stop-zebra
137
137
138
# koha-mysql autocompletes with a single instance name
138
# koha-mysql* autocompletes with a single instance name
139
complete -F _koha_single_instance koha-mysql
139
complete -F _koha_single_instance koha-mysql
140
complete -F _koha_single_instance koha-mysqldump
140
141
141
_koha_list()
142
_koha_list()
142
{
143
{
(-)a/debian/koha-common.install (+1 lines)
Lines 20-25 debian/scripts/koha-foreach usr/sbin Link Here
20
debian/scripts/koha-indexer                 usr/sbin
20
debian/scripts/koha-indexer                 usr/sbin
21
debian/scripts/koha-list                    usr/sbin
21
debian/scripts/koha-list                    usr/sbin
22
debian/scripts/koha-mysql                   usr/sbin
22
debian/scripts/koha-mysql                   usr/sbin
23
debian/scripts/koha-mysqldump               usr/sbin
23
debian/scripts/koha-passwd                  usr/sbin
24
debian/scripts/koha-passwd                  usr/sbin
24
debian/scripts/koha-plack                   usr/sbin
25
debian/scripts/koha-plack                   usr/sbin
25
debian/scripts/koha-rebuild-zebra           usr/sbin
26
debian/scripts/koha-rebuild-zebra           usr/sbin
(-)a/debian/scripts/koha-mysqldump (-1 / +59 lines)
Line 0 Link Here
0
- 
1
#!/bin/sh
2
#
3
# koha-mysqldump: run mysqldump on the database of the specified Koha instance.
4
# Copyright 2016 Barton Chittenden
5
# Based on koha-mysql, which is Copyright 2011  Catalyst IT, Ltd
6
#
7
# This program is free software: you can redistribute it and/or modify
8
# it under the terms of the GNU General Public License as published by
9
# the Free Software Foundation, either version 3 of the License, or
10
# (at your option) any later version.
11
#
12
# This program is distributed in the hope that it will be useful,
13
# but WITHOUT ANY WARRANTY; without even the implied warranty of
14
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
15
# GNU General Public License for more details.
16
#
17
# You should have received a copy of the GNU General Public License
18
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
19
20
set -e
21
22
umask 0077
23
24
# include helper functions
25
if [ -f "/usr/share/koha/bin/koha-functions.sh" ]; then
26
    . "/usr/share/koha/bin/koha-functions.sh"
27
else
28
    echo "Error: /usr/share/koha/bin/koha-functions.sh not present." 1>&2
29
    exit 1
30
fi
31
32
usage()
33
{
34
    local scriptname=$0
35
    cat <<EOF
36
Run mysqldump in the context of a given Koha instance.
37
38
Usage: $scriptname instancename [ optional mysqldump arguments ]
39
40
EOF
41
}
42
43
# Parse command line.
44
[ $# -ge 1 ] || ( usage ; die "Missing instance name..." )
45
46
name="$1"
47
48
is_instance "$name" || ( usage; die "Unknown instance '$name'" )
49
50
shift # remove instance name from argument list.
51
kohaconfig="/etc/koha/sites/$name/koha-conf.xml"
52
53
mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )"
54
mysqldb="$( xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )"
55
mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user' $kohaconfig )"
56
mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass' $kohaconfig )"
57
58
mysqldump --host="$mysqlhost" --user="$mysqluser" --password="$mysqlpass" \
59
    "$mysqldb"  "${@}"

Return to bug 12374