fastapi-starter/export.sh at master · coroo/fastapi-starter · 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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64

#!/bin/bash

export PATH=/bin:/usr/bin:/usr/local/bin
TODAY=`date +"%d%m%Y"`

################################################################
################## Update below values  ########################

DB_BACKUP_PATH=$(grep DB_BACKUP_PATH .env | cut -d '=' -f2) ## Insert Backup .sql path here
DB_HOST=$(grep DB_HOST .env | cut -d '=' -f2)
DB_PORT=$(grep DB_PORT .env | cut -d '=' -f2)
DB_USERNAME=$(grep DB_USERNAME .env | cut -d '=' -f2)
DB_PASSWORD=$(grep DB_PASSWORD .env | cut -d '=' -f2)
DB_DATABASE=$(grep DB_DATABASE .env | cut -d '=' -f2)
DB_CONTAINER_NAME=$(grep DB_CONTAINER_NAME .env | cut -d '=' -f2)
DB_BACKUP_TABLE_NAME=$(grep DB_BACKUP_TABLE_NAME .env | cut -d '=' -f2)
BACKUP_RETAIN_DAYS=$(grep BACKUP_RETAIN_DAYS .env | cut -d '=' -f2)   ## Number of days to keep local backup copy
MYSQLDUMP_LOC=$(which mysqldump)
if [${MYSQLDUMP_LOC} -eq '']; then
  MYSQLDUMP_LOC="/usr/local/opt/mysql@5.7/bin/mysqldump"
fi

#################################################################

mkdir -p ${DB_BACKUP_PATH}
echo "Backup started for database - ${DB_DATABASE}"

if [${DB_PASSWORD} -eq '']; then
  ${MYSQLDUMP_LOC} -u${DB_USERNAME} \
      -h ${DB_HOST} \
      -P ${DB_PORT} \
          ${DB_DATABASE} ${DB_BACKUP_TABLE_NAME} --skip-add-drop-table  > ${DB_BACKUP_PATH}/${DB_DATABASE}-${TODAY}.sql
else
  ${MYSQLDUMP_LOC} -u${DB_USERNAME} \
      -p${DB_PASSWORD} \
      -h ${DB_HOST} \
      -P ${DB_PORT} \
          ${DB_DATABASE} ${DB_BACKUP_TABLE_NAME} --skip-add-drop-table  > ${DB_BACKUP_PATH}/${DB_DATABASE}-${TODAY}.sql
  echo ${DB_PASSWORD}
fi

sed -i '' 's/CREATE TABLE \(.*\)/TRUNCATE TABLE \1; CREATE TABLE IF NOT EXISTS \1/g' ${DB_BACKUP_PATH}/${DB_DATABASE}-${TODAY}.sql
sed -i '' 's/ (; CREATE TABLE IF NOT EXISTS/; CREATE TABLE IF NOT EXISTS/g' ${DB_BACKUP_PATH}/${DB_DATABASE}-${TODAY}.sql

if [ $? -eq 0 ]; then
  echo "Database backup successfully completed"
else
  echo "Error found during backup"
fi


##### Remove backups older than {BACKUP_RETAIN_DAYS} days  #####

DBDELDATE=`date +"%d%m%Y" --date="${BACKUP_RETAIN_DAYS} days ago"`

if [ ! -z ${DB_BACKUP_PATH} ]; then
      cd ${DB_BACKUP_PATH}
      if [ ! -z ${DBDELDATE} ] && [ -d ${DBDELDATE} ]; then
            rm -rf ${DBDELDATE}
      fi
fi

### End of script ####