Linux за българи: Форуми

#!/bin/sh
mysqldump -uUSER_on_your_mysql_server -pPASS_on_Your_mysql_server --opt site > /sqldata/db1.sql


cd /sqldata/
tar -zcvf sqldata.tgz *.sql
cd /scripts/
perl emailsql.pl

#! /bin/bash

# your MySQL server's name

SERVER=neshtosi.com



# directory to backup to

BACKDIR=~/sqldata



# date format that is appended to filename

DATE=`date +'%m-%d-%Y'`



#----------------------MySQL Settings--------------------#



# your MySQL server's location (IP address is best)

HOST=localhost



# MySQL username

USER=root



# MySQL password

PASS=password



# List all of the MySQL databases that you want to backup in here, 

# each separated by a space

DBS="site_DB"



# set to 'y' if you want to backup all your databases. this will override

# the database selection above.

DUMPALL=y





#----------------------Mail Settings--------------------#



# set to 'y' if you'd like to be emailed the backup (requires mutt)

MAIL=n



# email addresses to send backups to, separated by a space

EMAILS="1@gmail.com 2@inbox.com 3@goowy.com"



SUBJECT="MySQL backup on $SERVER ($DATE)"



#----------------------FTP Settings--------------------#



# set "FTP=y" if you want to enable FTP backups

FTP=y



# FTP server settings; should be self-explanatory

FTPHOST="IP_HOST"

FTPUSER="User"

FTPPASS="Pass"



# directory to backup to. if it doesn't exist, file will be uploaded to 

# first logged-in directory

FTPDIR="backup"



#-------------------Deletion Settings-------------------#



# delete old files?

DELETE=n



# how many days of backups do you want to keep?

DAYS=3



#----------------------End of Settings------------------#



# check of the backup directory exists

# if not, create it

if  [ -e $BACKDIR ]

then

	echo Backups directory already exists

else

	mkdir $BACKDIR

fi



if  [ $DUMPALL = "y" ]

then

	echo "Backing up MySQL databases..."



	mysqldump -h $HOST -u$USER -p$PASS --opt $DBS > /sqldata/$DATE-db.sql


cd /sqldata
tar -zcvf $DATE-db.tgz *$DATE-db.sql


fi






# if you have the mail program 'mutt' installed on

# your server, this script will have mutt attach the backup

# and send it to the email addresses in $EMAILS



if  [ $MAIL = "y" ]

then

BODY="Your backup is ready!"

ATTACH=`for file in $BACKDIR/*$DATE-db.tar; do echo -n "-a ${file} ";  done`



	echo "$BODY" | mutt -s "$SUBJECT" $ATTACH $EMAILS

        

	echo -e "Your backup has been emailed to you! \n"

fi



if  [ $FTP = "y" ]

then

echo "Initiating FTP connection..."



ATTACH=`for file in *$DATE-db.tar; do echo -n "-a ${file} ";  done`


	ftp -nv <<EOF

	open $FTPHOST

	user $FTPUSER $FTPPASS

	cd /backup

	$ATTACH

	quit

EOF

echo -e  "FTP transfer complete! \n"

fi



if  [ $DELETE = "y" ]

then

	find $BACKDIR -name "*.sql.gz" -mtime $DAYS -exec rm {} \;



	if  [ $DAYS = "1" ]

	then

		echo "Yesterday's backup has been deleted."

	else

		echo "The backup from $DAYS days ago has been deleted."

	fi

fi



echo Your backup is complete!

ATTACH=`for file in *$DATE-db.tar; do echo -n "-a ${file} ";  done`