Subversion Repositories My Stuff

Rev

Rev 7 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
7 kardasa 1
#!/bin/sh
2
 
3
#####################################################################
4
# Script to beckup MySQL databases to separate files
5
# This script is distributed in the hope that it will be useful,
6
# but WITHOUT ANY WARRANTY; without even the implied warranty of
7
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
8
# GNU General Public License for more details.
9
# Author: Andrzej Kardaƛ
10
# License: GPLv3 
11
# The full version of the licencse can be obtainted by visiting: 
12
# http://www.gnu.org/licenses/gpl.html
13
#######################################################################
14
 
15
MYUSER=${1}
16
PASSWORD=${2}
17
BCKPATH=${3}
18
MYSQL="/usr/bin/mysql"
19
MYSQLDUMP="/usr/bin/mysqldump"
20
 
21
if [ -d ${BCKPATH} ]; then
22
        echo "Path seems ok"
23
        echo
24
else
25
        echo "Can not find the provided path check script parameters"
26
        echo
27
        exit 1
28
fi
29
 
30
DATABASES="$(${MYSQL} -u ${MYUSER} -p${PASSWORD} -Bse 'show databases')"
31
for name in ${DATABASES}
32
do
33
        FILE=${BCKPATH}/mysql-${name}-$(date +"%d_%m_%y").sql
34
        echo "Creating backup of database ${name} to file ${FILE}"
32 kardasa 35
        if (${MYSQLDUMP} -u ${MYUSER} -p${PASSWORD} ${name} >> ${FILE}) then
7 kardasa 36
                echo "Storing database ${name} in ${FILE} succesfull"
37
                echo
38
        else
39
                echo "Storing database ${name} in ${FILE} failed"
40
                echo
41
        fi
42
done