Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- MYSQL_USER="user"
- MYSQL_PASS="secret"
- MYSQL_NAME="database"
- MYSQL_ARGS="-u ${MYSQL_USER} -p${MYSQL_PASS} ${MYSQL_NAME}"
- DATE=`date +"%Y-%m-%d %H:%M"`
- BACKUPS_DIR="/srv/backups"
- BACKUPS_FILE="${BACKUPS_DIR}/${MYSQL_NAME}-${DATE}.sql.gz"
- if [ ! -d "$BACKUPS_DIR" ]; then
- mkdir $BACKUPS_DIR
- fi
- mysqldump ${MYSQL_ARGS} | gzip > "${BACKUPS_FILE}"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement