| /trunk/Bash/mysql_data_backup.sh |
|---|
| File deleted |
|---|
|
|
|---|
| Property changes: |
|---|
| Deleted: svn:executable |
|---|
| ## -1 +0,0 ## |
|---|
| -* |
|---|
| \ No newline at end of property |
|---|
| Index: Bash/mysql_db_data_backup.sh |
|---|
| =================================================================== |
|---|
| --- Bash/mysql_db_data_backup.sh (revision 31) |
|---|
| +++ Bash/mysql_db_data_backup.sh (nonexistent) |
|---|
| @@ -1,39 +0,0 @@ |
|---|
| -#!/bin/bash |
|---|
| - |
|---|
| -##################################################################### |
|---|
| -# Script to make data copy from given mysql database |
|---|
| -# |
|---|
| -# This script is distributed in the hope that it will be useful, |
|---|
| -# but WITHOUT ANY WARRANTY; without even the implied warranty of |
|---|
| -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
|---|
| -# GNU General Public License for more details. |
|---|
| -# Author: Andrzej Kardaś |
|---|
| -# License: GPLv3 |
|---|
| -# The full version of the licencse can be obtainted by visiting: |
|---|
| -# http://www.gnu.org/licenses/gpl.html |
|---|
| -####################################################################### |
|---|
| - |
|---|
| -MYUSER=${1} |
|---|
| -PASSWORD=${2} |
|---|
| -DATABASE=${3} |
|---|
| -BCKPATH=${4} |
|---|
| -MYSQL="/usr/bin/mysql" |
|---|
| -MYSQLDUMP="/usr/bin/mysqldump" |
|---|
| - if [ -d ${BCKPATH} ]; then |
|---|
| - echo "Path seems ok" |
|---|
| - echo |
|---|
| - else |
|---|
| - echo "Can not find the provided path check script parameters" |
|---|
| - echo |
|---|
| - exit 1 |
|---|
| - fi |
|---|
| - |
|---|
| - FILE=${BCKPATH}/mysql-data-${DATABASE}-$(date +"%d_%m_%y").sql |
|---|
| - echo "Creating backup of database ${DATABASE} to file ${FILE}" |
|---|
| - if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${DATABASE} > ${FILE}) then |
|---|
| - echo "Storing database ${DATABASE} in ${FILE} succesfull" |
|---|
| - echo |
|---|
| - else |
|---|
| - echo "Storing database ${DATABASE} in ${FILE} failed" |
|---|
| - echo |
|---|
| - fi |
|---|