0,0 → 1,41 |
#!/bin/bash |
|
##################################################################### |
# Script to make data copy from mysql |
# |
# 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} |
BCKPATH=${3} |
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 |
DATABASES="$(${MYSQL} -u ${MYUSER} -p${PASSWORD} -Bse 'show databases')" |
for name in ${DATABASES} |
do |
FILE=${BCKPATH}/mysql-data-${name}-$(date +"%d_%m_%y").sql |
echo "Creating backup of database ${name} to file ${FILE}" |
if (${MYSQLDUMP} --skip-triggers --compact --no-create-info --disable-keys -u ${MYUSER} -p${PASSWORD} ${name} > ${FILE}) then |
echo "Storing database ${name} in ${FILE} succesfull" |
echo |
else |
echo "Storing database ${name} in ${FILE} failed" |
echo |
fi |
done |
Property changes: |
Added: svn:executable |
## -0,0 +1 ## |
+* |
\ No newline at end of property |
Index: trunk/Bash/mysql_db_data_backup.sh |
=================================================================== |
--- trunk/Bash/mysql_db_data_backup.sh (nonexistent) |
+++ trunk/Bash/mysql_db_data_backup.sh (revision 31) |
@@ -0,0 +1,39 @@ |
+#!/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 |