Go to most recent revision | Details | 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}" |
||
35 | if (${MYSQLDUMP} -u ${MYUSER} -p${PASSWORD} ${name} > ${FILE}) then |
||
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 |