[kodi]

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

#!/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?