#!/bin/sh

#
# db_backup.sh
# Shell script to backup mysql databases
#
# -=*=- -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-
# this is the only user configurable section

USER=root
PASS=Secr@t
EMAIL=youremail@yahoo.com
HOST=localhost
DBNAME=comp
TABLES="ids users computers versions"

DEBUG=1
DESTPATH=backup

# please do not modify below this
# -=*=- -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-  -=*=-

TIMESTAMP=`date +%m%d%Y`
LOGFILE=db_backup_${TIMESTAMP}\.log
DESTFILE=${DBNAME}_backup.sql_$TIMESTAMP

if [ $DEBUG -eq 1 ]; then
    echo LOGFILE=$LOGFILE
    echo USER=$USER
    echo PASSWORD=$PASS
    echo DBNAME=$DBNAME
    echo TABLES=$TABLES
    echo DESTPATH=$DESTPATH
    echo DESTFILE=$DESTFILEfi
OPTIONS="--complete-insert"CMD="mysqldump --user ${USER} --password ${PASS} --hostname ${HOST} $OPTIONS ${DBNAME} > ${DESTFILE}"
echo ${CMD}
# uncomment
`${CMD}`
# move the current file to dest folder/file
CMD="mv ${DESTFILE} ${DESTPATH}"
echo ${CMD}
`${CMD}`

• Back to Imaging/Sysadmin