Changeset 199 for bin/backup_db.sh

Timestamp:

Apr 27, 2009, 9:40:00 AM (16 years ago)

Author:

george

Message:

• Upraveno: Zpřehlednění zálohovacího skriptu databáze.

File:

• bin/backup_db.sh (modified) (1 diff)

bin/backup_db.sh

@@ -3 +3 @@
 . config.sh
 
-echo Zaloha database...
+echo Zaloha databaze...
 
 mkdir /tmp/backup
 cd /tmp/backup
 
-echo IS
+DB_NAME=is
+echo ${DB_NAME}
+mysqldump --user=${DB_USER} --password=${DB_PASSWORD} ${DB_NAME} > ${DB_NAME}.sql
+tar -c -z is.sql > ${DB_BACKUP_DIR}${DB_NAME}/${DB_NAME}_$(date +"%Y-%m-%d").tar.gz
+unlink ${DB_NAME}.sql
 
-mysqldump --user=${DB_USER} --password=${DB_PASSWORD} centrala > is.sql
-
-tar -c -z is.sql > ${DB_BACKUP_DIR}centrala/is_$(date +"%Y-%m-%d").tar.gz
-
-unlink is.sql
-
-echo Share
-
-mysqldump --user=${DB_USER} --password=${DB_PASSWORD} --opt share > share.sql
-
-tar -c -z share.sql > ${DB_BACKUP_DIR}share/share_$(date +"%Y-%m-%d").tar.gz
-
-unlink share.sql
+DB_NAME=share
+echo ${DB_NAME}
+mysqldump --user=${DB_USER} --password=${DB_PASSWORD} ${DB_NAME} > ${DB_NAME}.sql
+tar -c -z is.sql > ${DB_BACKUP_DIR}${DB_NAME}/${DB_NAME}_$(date +"%Y-%m-%d").tar.gz
+unlink ${DB_NAME}.sql
 
 rmdir /tmp/backup