Advertisement
Guest User

Untitled

a guest
Jan 9th, 2018
324
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.17 KB | None | 0 0
  1. #!/bin/sh
  2.  
  3. echo "===== Backup started :" `date` "====="
  4.  
  5. #mysql database
  6. DB_NAME=store
  7. DB_USER=store_user
  8. DB_PASSWORD=...
  9. DB_DUMP_FILE_NAME=mysql_dump_`date +%F-%T`.sql
  10. TMP_FOLDER=temp_dumping_`date +%F-%T`
  11. PACKAGE_NAME=store_full_dump_`date +%F-%T`.zip
  12. DUMP_STORAGE=/usr/local/backup/store_dumps
  13.  
  14. mkdir $TMP_FOLDER
  15. cd $TMP_FOLDER
  16.  
  17. echo "Dumping database: $DB_NAME to $DB_DUMP_FILE_NAME ..."
  18. mysqldump $DB_NAME -u $DB_USER --password=$DB_PASSWORD > $DB_DUMP_FILE_NAME
  19.  
  20. echo "Copying web data..."
  21. cp -R /var/www/store .
  22. cp -R /var/www/opencart_storage .
  23.  
  24. echo "Zipping the package to: $PACKAGE_NAME..."
  25. zip -r $PACKAGE_NAME * > /dev/null
  26.  
  27. echo "Transfering to caroline..."
  28. sshpass -P assphrase -f "/usr/local/etc/caroline" scp -i /home/panda/.ssh/id_rsa                                                                                                                                                                              "./$PACKAGE_NAME" panda@sergey.medvedev.space:~/dumps
  29.  
  30. echo "Copying the package to: $DUMP_STORAGE..."
  31. mv $PACKAGE_NAME $DUMP_STORAGE
  32.  
  33. echo "Cleaning up..."
  34. rm -R *
  35. cd ..
  36. rm -R $TMP_FOLDER
  37.  
  38. echo "===== Backup finished :" `date` "====="
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement