Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # Database credentials
- DBUSER=""
- DBPASSWORD=""
- DBHOST="localhost"
- DBNAME=""
- USER="" # fe. myuser.mygroup
- # Other options
- BACKUP_PATH="./backup"
- DATE=$(date +"%d-%b-%Y")
- # Check if backup path exists
- mkdir -p ${BACKUP_PATH}
- # Set default file permissions
- umask 177
- # Dump database into SQL file
- mysqldump --user=${DBUSER} --password=${DBPASSWORD} --host=${DBHOST} ${DBNAME} >${BACKUP_PATH}/${DBNAME}-${DATE}.sql
- # Delete files older than 30 days
- find ${BACKUP_PATH}/* -mtime +30 -exec rm {} \;
- # Set user rights
- if [ ! -z "${USER}" ]; then
- chown -R ${USER} ${BACKUP_PATH}
- fi
- # Show output
- ls -la ${BACKUP_PATH}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement