Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- echo "===== Backup started :" `date` "====="
- #mysql database
- DB_NAME=store
- DB_USER=store_user
- DB_PASSWORD=...
- DB_DUMP_FILE_NAME=mysql_dump_`date +%F-%T`.sql
- TMP_FOLDER=temp_dumping_`date +%F-%T`
- PACKAGE_NAME=store_full_dump_`date +%F-%T`.zip
- DUMP_STORAGE=/usr/local/backup/store_dumps
- mkdir $TMP_FOLDER
- cd $TMP_FOLDER
- echo "Dumping database: $DB_NAME to $DB_DUMP_FILE_NAME ..."
- mysqldump $DB_NAME -u $DB_USER --password=$DB_PASSWORD > $DB_DUMP_FILE_NAME
- echo "Copying web data..."
- cp -R /var/www/store .
- cp -R /var/www/opencart_storage .
- echo "Zipping the package to: $PACKAGE_NAME..."
- zip -r $PACKAGE_NAME * > /dev/null
- echo "Transfering to caroline..."
- sshpass -P assphrase -f "/usr/local/etc/caroline" scp -i /home/panda/.ssh/id_rsa "./$PACKAGE_NAME" panda@sergey.medvedev.space:~/dumps
- echo "Copying the package to: $DUMP_STORAGE..."
- mv $PACKAGE_NAME $DUMP_STORAGE
- echo "Cleaning up..."
- rm -R *
- cd ..
- rm -R $TMP_FOLDER
- echo "===== Backup finished :" `date` "====="
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement