danas sam sredjivao ovo..
radi backup u lokalu i rsync celog backup dir-a sa remote serverom
zgodno, ako treba nesto dodatno da se bekapuje vezano za mysql, samo ga ubacim u taj dir i sledeci put kad ga cron pokrene to se bekapuje na remote server...
backup_mysql.sh
Kôd:
#!/bin/bash
#####################################
### MySQL Configuration Variables ###
#####################################
# MySQL Hostname
DBHOST='localhost'
# MySQL Username
DBUSER='kodi '
# MySQL Password
DBPASSWD='shatromojpass'
# Local Directory for Dump Files
LOCALDIR='/development/backup/_mysql_/'
# Remote Directory for Offsite Backup
REMOTEUSER='backup'
REMOTEHOST='linux-backup' #this linux-backup is defined in /etc/hosts
REMOTEDIR='/home/backup/powerMacBackup'
# Prefix for offsite .tar file backup
TARPREFIX='powerMacLocal'
#####################################
### Edit Below If Necessary #########
#####################################
cd $LOCALDIR
SUFFIX=`eval date +%y%m%d`
DBS=`/Applications/xampp/xamppfiles/bin/mysql -u$DBUSER -p$DBPASSWD -h$DBHOST -e"show databases"`
for DATABASE in $DBS
do
if [ $DATABASE != "Database" ]
then
FILENAME=$SUFFIX-$DATABASE.gz
/Applications/xampp/xamppfiles/bin/mysqldump -u$DBUSER -p$DBPASSWD -h$DBHOST $DATABASE | gzip --best > $LOCALDIR$FILENAME
fi
done
#TAR FILES INTO ONE FILE
tar -cf $TARPREFIX-$SUFFIX.tar $SUFFIX-*.gz
chmod 400 $LOCALDIR*.tar
rm *.gz
#RSYNC TO REMOTE BACKUP SERVER
# (set up ssh to auth using public keys first)
rsync -avz -e ssh --progress $LOCALDIR $REMOTEUSER@$REMOTEHOST:$REMOTEDIR
edit:
zasto je code box ovako uzak?