Subversion Repositories My Stuff

Rev

Rev 7 | Only display areas with differences | Ignore 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