<commit_before>#!/bin/sh

. ~/Repos/Scripts/bash/common/utilities.sh
. ~/Repos/Scripts/.secrets/secrets.sh

logCron "Attempting to backup/dump 'alb3rtuk' EC2 MySQL DB to local repo."

date="$(date +%Y-%m-%d)"

mysqldump -h ${EC2_MYSQL_ALB3RTUK_HOST} -P 3306 -u ${EC2_MYSQL_ALB3RTUK_ROOT_USER} -p${EC2_MYSQL_ALB3RTUK_ROOT_PASS} ${EC2_MYSQL_ALB3RTUK_DEFAULT_SCHEMA} > $HOME/Repos/SQL-Backups/alb3rtuk/alb3rtuk-${date}.sql<commit_msg>Minor changes to script which backs up SQL DBs to repo.<commit_after>#!/bin/sh

. ~/Repos/Scripts/bash/common/utilities.sh
. ~/Repos/Scripts/.secrets/secrets.sh

logCron "Attempting to backup/dump 'alb3rtuk' EC2 MySQL DB to local repo."

date="$(date +%Y-%m-%d)"

mysqldump -h ${EC2_MYSQL_ALB3RTUK_HOST} -P 3306 -u ${EC2_MYSQL_ALB3RTUK_ROOT_USER} -p${EC2_MYSQL_ALB3RTUK_ROOT_PASS} ${EC2_MYSQL_ALB3RTUK_DEFAULT_SCHEMA} > $HOME/Repos/sql-backups/alb3rtuk/alb3rtuk-${date}.sql
{'fraction_non_alphanumeric': 0.15376106194690264, 'fraction_numerical': 0.035398230088495575, 'mean_word_length': 5.557971014492754, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3390495', 'n_tokens_mistral': 435, 'n_tokens_neox': 422, 'n_words': 61}