Storage.py - has a connection to BackBlaze, which picks up a file from static folder and sends it for storage, storage link gets generated from BackBlaze. That job will run the script at 2AM and 1PM and also will write the log to the - runs basic flask app, which imports file to MySQL database using SQLAlchemy.

ssh to server and copy the script to serverĠ0 02,13 * * * /home/aslam/script-list/backup.sh > /home/aslam/script-list/logfile 2>&1.

Now that we have the script, it’s time to setup cron job for auto daily backup. I use /usr/local/bin/b2 because in crontab it must use absolute path. The continuation of shell script above: # upload to b2 B2_ACC_ID='' B2_APP_KEY='' B2_BUCKET_NAME='' echo 'starting upload db to b2 at $(date +'%d-%m-%Y %H:%M:%S')' /usr/local/bin/b2 authorize-account $B2_ACC_ID $B2_APP_KEY /usr/local/bin/b2 upload_file $B2_BUCKET_NAME $BACKUP_DIR $FILENAME echo 'finished uploading db to b2 at $(date +'%d-%m-%Y %H:%M:%S')' exit 0īasically this script will authorise the backblaze account first, and then upload the compressed db to the bucket in backblaze. Install the backblaze cli using pip: pip install b2

Creating a bucket in Backblaze also super easy: We need a bucket to store the database dump. We just need the account id and application key. I chose backblaze because it has the best price among others. Mysqldump command will dump your database, compress it using gzip, and then save it in the backup directory (BACKUP_DIR). I added today’s date in the backup filename to make it easier to differentiate which one is the new one. The first step is to declare your database information like database name, host, password, and db user. #!/bin/bash DB_NAME='' DB_PASSWORD='' DB_USER='' DB_HOST='' TODAY_DATE='$(date +'%d_%m_%Y_%H_%M_%S')' FILENAME='$DB_NAME$TODAY_DATE'.gz BACKUP_DIR='/home/aslam/backup/$FILENAME' # dump db in backup folder echo 'mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')' mysqldump -u $DB_USER -p$DB_PASSWORD -h $DB_HOST -e -opt -c $DB_NAME | gzip -c > $BACKUP_DIR echo 'mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')' Why shell script? Because it’s easy to setup script that runs an external command like in this case, mysqldump.

Backblaze storage