BitrixDocker/mysql_backuper.sh at master · Vampiref92/BitrixDocker · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
#!/bin/bash

function backup_mysql(){
	DB_NAME=$1
	DB_USER=$2
	DB_PASSWORD=$3
	BACKUP_NAME=getNeedValue $4 "bitrix"
	mysqldump -u ${DB_USER} -p${DB_PASSWORD} ${DB_NAME} > ${BACKUP_NAME}.sql
}

function backup_mysql_gz(){
	DB_NAME=$1
	DB_USER=$2
	DB_PASSWORD=$3
	BACKUP_NAME=getNeedValue $4 "bitrix"
	mysqldump -u ${DB_USER} -p${DB_PASSWORD} ${DB_NAME} | gzip  > ${BACKUP_NAME}.sql.gz
}


function restore_mysql(){
	DB_NAME=$1
	DB_USER=$2
	DB_PASSWORD=$3
	BACKUP_NAME=getNeedValue $4 "bitrix"
	mysql -u${DB_USER} -p${DB_PASSWORD} ${DB_NAME} -P 3306 < ${BACKUP_NAME}.sql
}

function restore_mysql_gz(){
	DB_NAME=$1
	DB_USER=$2
	DB_PASSWORD=$3
	BACKUP_NAME=getNeedValue $4 "bitrix"
	gunzip < ${BACKUP_NAME}.sql.gz | mysql -u ${DB_USER} -p${DB_PASSWORD} ${DB_NAME}
}

function getNeedValue(){
    CHECK_VALUE=$1
    DEFAULT_VALUE=$2
    if [[ -n $CHECK_VALUE ]]; then
        echo $CHECK_VALUE
    else
        echo $DEFAULT_VALUE
    fi
}