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