Subversion Repositories My Stuff

Rev

Rev 31 | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31 Rev 32
1 
#!/bin/bash
1 
#!/bin/bash
2 

            2
            

          

          

            3
            
#####################################################################


            3
            
#####################################################################


          

          

            4
            
# Script to make data copy from given mysql database


            4
            
# Script to make data copy from given mysql database


          

          

            5
            
#


            5
            
#


          

          

            6
            
# This script is distributed in the hope that it will be useful,


            6
            
# This script is distributed in the hope that it will be useful,


          

          

            7
            
# but WITHOUT ANY WARRANTY; without even the implied warranty of


            7
            
# but WITHOUT ANY WARRANTY; without even the implied warranty of


          

          

            8
            
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the


            8
            
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the


          

          

            9
            
# GNU General Public License for more details.


            9
            
# GNU General Public License for more details.


          

          

            10
            
# Author: Andrzej Kardaś


            10
            
# Author: Andrzej Kardaś


          

          

            11
            
# License: GPLv3 


            11
            
# License: GPLv3 


          

          

            12
            
# The full version of the licencse can be obtainted by visiting: 


            12
            
# The full version of the licencse can be obtainted by visiting: 


          

          

            13
            
# http://www.gnu.org/licenses/gpl.html


            13
            
# http://www.gnu.org/licenses/gpl.html


          

          

            14
            
#######################################################################


            14
            
#######################################################################


          

          

            15
            

            15
            

          

          

            16
            
MYUSER=${1}


            16
            
MYUSER=${1}


          

          

            17
            
PASSWORD=${2}


            17
            
PASSWORD=${2}


          

          

            18
            
DATABASE=${3}


            18
            
DATABASE=${3}


          

          

            19
            
BCKPATH=${4}


            19
            
BCKPATH=${4}


          

          

            20
            
MYSQL="/usr/bin/mysql"


            20
            
MYSQL="/usr/bin/mysql"


          

          

            21
            
MYSQLDUMP="/usr/bin/mysqldump"


            21
            
MYSQLDUMP="/usr/bin/mysqldump"


          

          

            22
            
  if [ -d ${BCKPATH} ]; then


            22
            
  if [ -d ${BCKPATH} ]; then


          

          

            23
            
       echo "Path seems ok"


            23
            
       echo "Path seems ok"


          

          

            24
            
       echo


            24
            
       echo


          

          

            25
            
  else


            25
            
  else


          

          

            26
            
       echo "Can not find the provided path check script parameters"


            26
            
       echo "Can not find the provided path check script parameters"


          

          

            27
            
       echo


            27
            
       echo


          

          

            28
            
       exit 1


            28
            
       exit 1


          

          

            29
            
  fi


            29
            
  fi


          

          

            30
            

            30
            

          

          

            31
            
  FILE=${BCKPATH}/mysql-data-${DATABASE}-$(date +"%d_%m_%y").sql


            31
            
  FILE=${BCKPATH}/mysql-data-${DATABASE}-$(date +"%d_%m_%y").sql


          

          

            32
            
  echo "Creating backup of database ${DATABASE} to file ${FILE}"


            32
            
  echo "Creating backup of database ${DATABASE} to file ${FILE}"


          

          

            33
            
  if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${DATABASE} > ${FILE}) then


            -
            
 

          

          

            -
            
 

            33
            
  echo "SET FOREIGN_KEY_CHECKS = 0;" > ${FILE}


          

          

            -
            
 

            34
            
  if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${DATABASE} >> ${FILE}) then


          

          

            34
            
     echo "Storing database ${DATABASE} in ${FILE} succesfull"


            35
            
     echo "Storing database ${DATABASE} in ${FILE} succesfull"


          

          

            35
            
     echo


            36
            
     echo


          

          

            -
            
 

            37
            
     echo "SET FOREIGN_KEY_CHECKS =1;" >> ${FILE}


          

          

            36
            
  else


            38
            
  else


          

          

            37
            
     echo "Storing database ${DATABASE} in ${FILE} failed"


            39
            
     echo "Storing database ${DATABASE} in ${FILE} failed"


          

          

            38
            
     echo


            40
            
     echo


          

          

            -
            
 

            41
            
     rm -rf  ${FILE}


          

          

            39
            
  fi


            42
            
  fi


          

          

            40
            
 


            43