Django 3 Web Development Cookbook - Fourth Edition

How to do it...

To back up and restore your MySQL database, perform these steps:

1. Under the commands directory in your project's home directory, create a bash script: backup_mysql_db.sh. Start the script with variable and function definitions, as follows:

/home/myproject/commands/backup_mysql_db.sh#!/usr/bin/env bashSECONDS=0export DJANGO_SETTINGS_MODULE=myproject.settings.productionPROJECT_PATH=/home/myprojectREPOSITORY_PATH=${PROJECT_PATH}/src/myprojectLOG_FILE=${PROJECT_PATH}/logs/backup_mysql_db.logDAY_OF_THE_WEEK=$(LC_ALL=en_US.UTF-8 date +"%w-%A")DAILY_BACKUP_PATH=${PROJECT_PATH}/db_backups/${DAY_OF_THE_WEEK}.sqlLATEST_BACKUP_PATH=${PROJECT_PATH}/db_backups/latest.sqlerror_counter=0echoerr() { echo "$@" 1>&2; }cd ${PROJECT_PATH}mkdir ...