Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- DBNAME="dbname"
- DBHOST="localhost"
- DBUSER="root"
- DBPASS="12345"
- SFTPUSER="username"
- SFTPHOST="host"
- SFTPPATH="/path/to/backup/directory"
- # Oh Oh Oh Oh, cant't touch this
- # Generate output file name
- FILENAME=db_backup_$(date +"%Y_%m_%d_%H_%M_%S").sql
- OUTPUTFILE=~/.tmp/db_backup_script/$FILENAME
- ZIPPEDOUTPUTFILE=${OUTPUTFILE}.tar.gz
- # Create temp dir
- mkdir -p ~/.tmp/db_backup_script
- # Export database to file
- mysqldump -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME > $OUTPUTFILE
- # Zip the file
- tar cfz $ZIPPEDOUTPUTFILE $OUTPUTFILE
- # Upload file
- scp $ZIPPEDOUTPUTFILE ${SFTPUSER}@${SFTPHOST}:${SFTPPATH}/${FILENAME}.tar.gz
- # Clean up
- rm -rf ~/.tmp/db_backup_script
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement