Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- ##-----------------------Database Access--------------------------##
- DB_NAME="dbname"
- DB_USER="dbuser"
- DB_PASSWORD="dbpass"
- ##-----------------------Folder Web or Folder you want to backup--------------------------##
- NameOfFolder=("seatide")
- SourceOfFolder="/home/source"
- BackupLocation="/backups"
- date=$(date +"%Y-%m-%d")
- Sitename="SEATIDE"
- ##That mean, you will Backup the folder /home/albennet and will save into Folder /backups
- if [ ! -d $BackupLocation ]; then
- mkdir -p $BackupLocation
- fi
- find $BackupLocation/*.zip -mtime +10 -exec rm {} \;
- for fd in $NameOfFolder; do
- # Name of the Backup File
- file=$Sitename-$fd-$date.zip
- # Zip the Folder you will want to Backup
- echo "Starting to zip the folder and files"
- cd $SourceOfFolder
- zip -r $BackupLocation/$file $fd
- sleep 5s
- mysqldump -u $DB_USER -p$DB_PASSWORD $DB_NAME | gzip > $BackupLocation/$Sitename-$date-$DB_NAME.sql.tar
- sleep 5s
- ##Process Upload Files to Google Drive
- drive upload --file /backups/$file
- sleep 5s
- drive upload --file /backups/$Sitename-$date-$DB_NAME.sql.tar
- if test $? = 0
- then
- echo $Sitename."Your Data Successfully Uploaded to the Google Drive!"
- echo -e $Sitename."Your Data Successfully created and uploaded to the Google Drive!" | mail -s "Your VPS Backup from $date" cahyorizqullah@gmail.com
- else
- echo "Error in Your Data Upload to Google Drive" > $LOG_FILE
- fi
- done
Add Comment
Please, Sign In to add comment