Skip to content

Instantly share code, notes, and snippets.

@gadelkareem gadelkareem/mysql.sh
Created Jun 11, 2019

Embed
What would you like to do?
#!/usr/bin/env bash
set -euo pipefail
cd `dirname $0`
# lock it
PIDFILE="/tmp/$(basename "${BASH_SOURCE[0]%.*}.pid")"
exec 200>${PIDFILE}
flock -n 200 || ( echo "${BASH_SOURCE[0]} script is already running. Aborting . ." && exit 1 )
PID=$$
echo ${PID} 1>&200
TIMESTAMP=$(date '+%Y_%m_%d__%H_%M_%S')
mkdir -p /var/backups/databases
cd /var/backups/databases
function backup(){
DB=${1}
FILENAME=${TIMESTAMP}.sql.bz2
ROUTE="${DB}/${ENV}"
DIR=/var/backups/databases/${ROUTE}
FILE="${DIR}/${FILENAME}"
mkdir -p "${DIR}"
cd "${DIR}"
echo Backing up ${DB}
mysqldump -uroot --skip-lock-tables --single-transaction --add-drop-table ${DB} | bzip2 > ${FILE}
echo Uploading ${DB}
/usr/bin/s3cmd put ${FILE} s3://backups/db/${ROUTE}/${FILENAME}
rm -f ${FILE}
echo ${FILENAME} > latest
/usr/bin/s3cmd put latest "s3://backups/db/${ROUTE}/latest"
rm -f latest
}
function restore(){
DB=${1}
ROUTE="${DB}/${ENV}"
DIR=/var/backups/databases/${ROUTE}
mkdir -p "${DIR}"
cd "${DIR}"
/usr/bin/s3cmd get --force s3://backups/db/${ROUTE}/latest
/usr/bin/s3cmd get --force s3://backups/db/${ROUTE}/$(cat latest) - > latest.sql.bz2
bzcat latest.sql.bz2 | mysql -uroot ${DB}
rm -f latest
rm -f latest.sql.bz2
}
for i in "${@:2}"
do
$1 $i
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.