forum.lissyara.su

Код: Выделить всё

#!/bin/sh

backup_dir="/usr/backup"
name=`/bin/date -v -7d "+%Y-%m-%d"`
message="Бэкапы БД были успешно выполнены!!!!!"
message2="Удаление старых Бэкапов было выполнено удачно (-7)!!!!!"
subject="Backups"
subject2="Delete old backups"
sendxmpp="/usr/local/bin/sendxmpp"

if
tar -czvf $backup_dir/sams_backup_mysql_`date +'%Y-%m-%d'`.tar.gz /usr/db/mysql/*
tar -czvf $backup_dir/catalog_usr-local-etc_`date +'%Y-%m-%d'`.tar.gz /usr/local/etc/*
tar -czvf $backup_dir/catalog_etc_`date +'%Y-%m-%d'`.tar.gz /etc/*
tar -czvf $backup_dir/www_backup_`date +'%Y-%m-%d'`.tar.gz /usr/local/www/*
tar -czvf $backup_dir/rejik3_backup_`date +'%Y-%m-%d'`.tar.gz /usr/local/rejik/*
then
echo "$message" | $sendxmpp -s "$subject" admin@jabber.domain.ru
fi

if
rm $backup_dir/rejik3_backup_"$name".tar.gz
rm $backup_dir/catalog_etc_"$name".tar.gz
rm $backup_dir/catalog_usr-local-etc_"$name".tar.gz
rm $backup_dir/sams_backup_mysql_"$name".tar.gz
rm $backup_dir/www_backup_"$name".tar.gz
then
echo "$message2" | $sendxmpp -s "$subject2" admin@jabber.domain.ru
fi

Код: Выделить всё

root@ ~> cat /backup/mysql.sh
#!/bin/sh

# backup mysql for *****************
# username: backup
# password: *****************
# privileges: SELECT , PROCESS, FILE , SHOW DATABASES , LOCK TABLES, SHOW VIEW

#CREATE USER 'backup'@'localhost' IDENTIFIED BY  '*******';
#GRANT SELECT , PROCESS, FILE , SHOW DATABASES , LOCK TABLES, SHOW VIEW ON * . * TO  'backup'@'localhost' IDENTIFIED BY  '*********';

BACKUPDIR="/backup/mysql"
BACKUPDB="all"
MYSQL="/usr/local/bin/mysql"
MYSQLDUMP="/usr/local/bin/mysqldump"
OPTS=""
USERNAME="backup"
PASSWORD="*****"
SED="/usr/bin/sed"
DATE=`date "+%Y-%m-%d"`
MKDIR="/bin/mkdir -m 700"

if [ ! -d ${BACKUPDIR}/${DATE}  ]; then
    ${MKDIR} ${BACKUPDIR}/${DATE}
fi

if [ ${BACKUPDB} = all ]; then
        BACKUPDB=`${MYSQL} --user=${USERNAME} --password=${PASSWORD} --batch --skip-column-names -e "show databases" | ${SED} 's/ /%/g'`
fi

for NDM in ${BACKUPDB}
do
        if [ ${NDM} = information_schema ]; then
                OPTS="${OPTS} --skip-lock-tables"
        fi
        ${MYSQLDUMP} --user=${USERNAME} --password=${PASSWORD} ${OPTS} ${NDM} > ${BACKUPDIR}/${DATE}/${NDM}.sql
done