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

(-)a/debian/docs/koha-mysqlcheck.xml (+44 lines)
Line 0 Link Here
1
<article xmlns='http://docbook.org/ns/docbook'>
2
<title>koha-mysqlcheck</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-mysqlcheck">
12
13
  <refmeta>
14
    <refentrytitle>koha-mysqlcheck</refentrytitle>
15
    <manvolnum>8</manvolnum>
16
  </refmeta>
17
18
  <refnamediv>
19
    <refname>koha-mysqlcheck</refname>
20
    <refpurpose>Run <command>mysqlcheck</command> on the database of the specified Koha instance.</refpurpose>
21
    <refclass>UNIX/Linux</refclass>
22
  </refnamediv>
23
24
  <refsynopsisdiv>
25
    <cmdsynopsis>
26
      <command>koha-mysqlcheck</command> <arg><option>...</option></arg> <arg choice="req" rep="norepeat"><replaceable>instancename</replaceable></arg>
27
    </cmdsynopsis>
28
  </refsynopsisdiv>
29
30
  <refsect1><title>Description</title>
31
  <para>Run <command>mysqlcheck</command> on the database of the specified Koha instance.</para>
32
  <para>Any arguments provided before the name of the instance are passed directly to <command>mysqlcheck</command>. This means that all the operations of <command>mysqlcheck</command> are available through this script.</para>
33
  </refsect1>
34
35
  <refsect1><title>See also</title>
36
  <simplelist type="inline">
37
    <member><command>mysqlcheck(1)</command></member>
38
    <member><command>koha-mysql(8)</command></member>
39
  </simplelist>
40
  </refsect1>
41
  
42
</refentry>
43
44
</article>
(-)a/debian/scripts/koha-mysqlcheck (-1 / +49 lines)
Line 0 Link Here
0
- 
1
#!/bin/bash
2
#
3
# koha-mysqlcheck: run mysqlcheck on the database of the specified Koha instance.
4
# Copyright 2013 Magnus Enger Librioech
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
die() {
25
    echo "$@" 1>&2
26
    exit 1
27
}
28
29
# Parse command line.
30
if [ $# -lt 1 ]; then
31
    die "Usage: $0 [options] instancename"
32
fi
33
34
# Separate any arguments from the instance name
35
array=($@)
36
len=${#array[@]}
37
name=${array[$len-1]}
38
args=${array[@]:0:$len-1}
39
40
kohaconfig="/etc/koha/sites/$name/koha-conf.xml"
41
42
mysqlhost="$( xmlstarlet sel -t -v 'yazgfs/config/hostname' $kohaconfig )"
43
mysqldb="$(   xmlstarlet sel -t -v 'yazgfs/config/database' $kohaconfig )"
44
mysqluser="$( xmlstarlet sel -t -v 'yazgfs/config/user'     $kohaconfig )"
45
mysqlpass="$( xmlstarlet sel -t -v 'yazgfs/config/pass'     $kohaconfig )"
46
47
mysqlcheck --host="$mysqlhost" --user="$mysqluser" --password="$mysqlpass" \
48
    $args "$mysqldb"
49

Return to bug 10782