Skip to content

Instantly share code, notes, and snippets.

@tolleiv
Created April 14, 2012 20:35
Show Gist options
  • Save tolleiv/2387793 to your computer and use it in GitHub Desktop.
Save tolleiv/2387793 to your computer and use it in GitHub Desktop.
T3o restore_backup
#!/bin/bash
# Get absolute path to main directory
ABSPATH=$(cd "${0%/*}" 2>/dev/null; echo "${PWD}/${0##*/}")
SOURCE_DIR=`dirname "${ABSPATH}"`
#######################################################################
# Check for required binaries
if ! which mysql > /dev/null; then
echo "mysql command not found in path, please correct and run again"
exit 1
fi
if ! which rsync > /dev/null; then
echo "rsync command not found in path, please correct and run again"
exit 1
fi
# Get command line parameters
USAGE() {
echo "Usage:"
echo " $0 [-u <db user>] [-p <db pass> | -P] [-h <db host>] -d <database> -r <portal root> -s <backup directory> [-f] [-v]"
echo
echo "Option -P forces MySQL to ask for the password on the standard input."
echo "Option -f skips confirmation prompt"
echo "Option -v add verbose output"
exit $1
}
ARG_DBUSER=""
ARG_DBPASS=""
ARG_DBUSEPASS=""
ARG_DBHOST="localhost"
ARG_DB=""
ARG_DESTDIR=""
ARG_SRCDIR=""
ARG_FORCE=""
ARG_VERBOSE=""
while getopts 'u:p:Ph:d:r:s:fv' OPTION ; do
case "${OPTION}" in
u)
ARG_DBUSER="${OPTARG}"
;;
p)
ARG_DBPASS="${OPTARG}"
;;
P)
ARG_DBUSEPASS="yes"
;;
h)
ARG_DBHOST="${OPTARG}"
;;
d)
ARG_DB="${OPTARG}"
;;
r)
ARG_DESTDIR="${OPTARG}"
;;
s)
ARG_SRCDIR="${OPTARG}"
;;
f)
ARG_FORCE="yes"
;;
v)
ARG_VERBOSE="yes"
;;
\?)
USAGE 1
;;
esac
done
# Check command line parameters
if [ -z "${ARG_DESTDIR}" ]; then
echo "$0: missing required option -- r"
USAGE 1
elif [ ! -d "${ARG_DESTDIR}" ]; then
echo "Incorrect destination directory, directory does not exist"
USAGE 1
fi
if [ -z "${ARG_SRCDIR}" ]; then
echo "$0: missing required option -- s"
USAGE 1
elif [ ! -d "${ARG_SRCDIR}/database" -o ! -d "${ARG_SRCDIR}/filesystem" ]; then
echo "Incorrect source directory, must be the folder containing the database and filesystem subfolders"
USAGE 1
fi
# Prepare MySQL command line parameters
MYSQL_OPTIONS=""
if [ -n "${ARG_DBUSER}" ]; then
MYSQL_OPTIONS="${MYSQL_OPTIONS} -u${ARG_DBUSER}"
fi
if [ -n "${ARG_DBHOST}" ]; then
MYSQL_OPTIONS="${MYSQL_OPTIONS} -h${ARG_DBHOST}"
fi
if [ -z "${ARG_DB}" ]; then
echo "$0: missing required option -- d"
USAGE 1
fi
if [ -n "${ARG_DBUSEPASS}" ]; then
MYSQL_OPTIONS="${MYSQL_OPTIONS} -p"
elif [ -n "${ARG_DBPASS}" ]; then
MYSQL_OPTIONS="${MYSQL_OPTIONS} -p${ARG_DBPASS}"
fi
if [ -z "${ARG_FORCE}" ]; then
echo "About to delete database and restore backup from ${ARG_SRCDIR} into ${ARG_DESTDIR}"
echo "using database ${ARG_DB}@${ARG_DBHOST}"
echo -n "Press <ENTER> to continue or <CTRL>-C to abort... "
read
echo
fi
# Deploy filesystemystem
[ -n "${ARG_VERBOSE}" ] && echo -n "Deploying filesystem... "
rsync -rlpt --delete "${ARG_SRCDIR}/filesystem/" "${ARG_DESTDIR}"
mkdir -p "${ARG_DESTDIR}/htdocs/typo3temp"
[ -n "${ARG_VERBOSE}" ] && echo "done"
# Empty Database
[ -n "${ARG_VERBOSE}" ] && echo "Emptying database... "
mysql ${MYSQL_OPTIONS} -e "DROP DATABASE IF EXISTS \`${ARG_DB}\`"
mysql ${MYSQL_OPTIONS} -e "CREATE DATABASE \`${ARG_DB}\`"
# Deploy database
[ -n "${ARG_VERBOSE}" ] && echo "Deploying database... "
(
cd "${ARG_SRCDIR}/database"
for SQL in structure.sql data_*.sql full_*.sql; do
if [ -r "${SQL}" ]; then
[ -n "${ARG_VERBOSE}" ] && echo -n " - ${SQL}... "
mysql ${MYSQL_OPTIONS} "${ARG_DB}" < "${SQL}"
[ -n "${ARG_VERBOSE}" ] && echo "done"
fi
done
); [ $? -eq 0 ]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment