source: src/sqlbackup.sh @ 643

#!/bin/sh

# $Id: sqlbackup.sh,v 1.9 2005/05/04 16:20:14 anarcat Exp $
# ----------------------------------------------------------------------
# AlternC - Web Hosting System
# Copyright (C) 2002 by the AlternC Development Team.
# http://alternc.org/
# ----------------------------------------------------------------------
# Based on:
# Valentin Lacambre's web hosting softwares: http://altern.org/
# ----------------------------------------------------------------------
# LICENSE
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License (GPL)
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# To read the license please visit http://www.gnu.org/copyleft/gpl.html
# ----------------------------------------------------------------------
# Original Author of file: Benjamin Sonntag - 2003-03-23
# Purpose of file: MySQL Database backup shell script for AlternC
# ----------------------------------------------------------------------

# Get mysql user and password : 
. /etc/alternc/local.sh

function dobck {
    read RECORD
    while [ "$RECORD" ]
    do
        # login, pass, bck_history, bck_gzip, bck_dir
        LOGIN=`echo "$RECORD"|cut -f 1`
        PASS=`echo "$RECORD"|cut -f 2`
        DB=`echo "$RECORD"|cut -f 3`
        COUNT=`echo "$RECORD"|cut -f 4`
        COMPRESSED=`echo "$RECORD"|cut -f 5`
        TARGET_DIR=`echo "$RECORD"|cut -f 6`
    
        if [ $COMPRESSED -eq 1 ]
            then
            EXT=".gz"
        fi
        i=$COUNT
        while [ $i -gt 1 ]
        do
          next_i=$(($i - 1))
          mv -f "$TARGET_DIR/$DB.sql.$next_i$EXT" "$TARGET_DIR/$DB.sql.$i$EXT" 2>/dev/null
          i=$next_i # loop should end here
        done
        mv -f "$TARGET_DIR/$DB.sql$EXT" "$TARGET_DIR/$DB.sql.$i$EXT" 2>/dev/null
        if [ $COMPRESSED -eq 1 ]
            then
            mysqldump -u"$LOGIN" -p"$PASS" "$DB" | gzip -c > "$TARGET_DIR/$DB.sql$EXT"
        else
            mysqldump -u"$LOGIN" -p"$PASS" "$DB" >"$TARGET_DIR/$DB.sql"
        fi

        read RECORD
    done
}

if [ "X$1" == "Xdaily" ]; then
# Daily : 
        mode=2
else
# weekly:
        mode=1
fi

/usr/bin/mysql -u"$MYSQL_USER" -p"$MYSQL_PASS" "$MYSQL_DATABASE" -B -e "SELECT login, pass, db, bck_history, bck_gzip, bck_dir FROM db WHERE bck_mode=$mode;" |grep -v "^login" | dobck