Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- #
- # Use this script to perform a backup of a MySQL database.
- #
- # The database name
- db_name="database1"
- # The host name of the MySQL database server; usually 'localhost'
- db_host="localhost"
- # The port number of the MySQL database server; usually '3306'
- db_port="3306"
- # The MySQL user to use when performing the database backup.
- db_user=""
- # The password for the above MySQL user.
- db_pass=""
- # Directory to which backup files will be written. Should end with slash ("/").
- backups_dir="/home/deploy/Backup/"
- # The system username
- backups_user="deploy"
- # Date/time included in the file names of the database backup files.
- datetime=$(date +'%Y-%m-%dT%H:%M:%S')
- # Create database backup and compress using gzip.
- mysqldump -u $db_user -h $db_host -P $db_port --password=$db_pass $db_name | gzip -9 > $backups_dir$db_name--$datetime.sql.gz
- # Set appropriate file permissions/owner.
- chown $backups_user:$backups_user $backups_dir*--$datetime.sql.gz
- chmod 0400 $backups_dir*--$datetime.sql.gz
Add Comment
Please, Sign In to add comment