mysql_backup.sh

#! /bin/bash
# Author: 	Nyle Davis			Created 12-04-20
# Purpose:	Backup all MySQL DBs and tables
# File:		mysql_backup.sh
# Run this with command:
# bash ../Scripts/Backups/mysql_backup.sh (options)
#			Options:
#				1=mode: daily, system
#				2=path: alternate backup path, such as flash or network
# Script is CRON capable

run_type=$1;
if [ ${run_type} = "daily" ]; then
	flname="mysql_daily_("`eval date +%Y-%m-%d`").tgz";
	bkpath='/data/Backups';
elif [ ${run_type} = "system" ]; then
	flname="mysql_system_("`eval date +%Y-%m-%d`").tgz";
	bkpath='/backups/Laptops/Aspire';
else
	echo "No Run-Type option selected! ";
fi
if [ ${2} != "" ]; then
	bkpath="${2}";
fi


# Backup DBs
dbuser='dbuser';
dbpass='dbpass';
dbpath='/usr/bin';
dbopts='--add-drop-database --add-drop-table';
cd ${bkpath};
rm -f "${flname}";
GZIP="$(which gzip)"
${dbpath}/mysqldump -u ${dbuser} -p${dbpass} ${dbopts} -A -C -f | $GZIP -9 > ${flname};

# May have to additionally manually backup the phpmyadmin option DB as sometime does not work correctly