Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- filename="$(date +"%s_%F_%k_%M_%S")"
- dateNow="$(date +"%F_%k_%M_%S")"
- homeDir="/home/timer/mysql_backup"
- homeDirTar="home/timer/mysql_backup"
- # create all backups
- mysqldump -C -c -e --user=backup --password=AQ dbc_blog > "$homeDir"/data/dbc_blog_"$filename".sql
- #mysqldump -C -c -e --user=backup --password=AQ phpbb3 > "$homeDir"/data/phpbb3_"$filename".sql
- #mysqldump -C -c -e --user=backup --password=AQ roundcube > "$homeDir"/data/roundcube_"$filename".sql
- #mysqldump -C -c -e --user=backup --password=AQ mss_forum > "$homeDir"/data/mss_forum_"$filename".sql
- #mysqldump -C -c -e --user=backup --password=AQ task > "$homeDir"/data/task_"$filename".sql
- # compress them
- sudo -u timer tar czf "$homeDir"/data/dbc_blog_"$filename".tar.gz -C / "$homeDirTar"/data/dbc_blog_"$filename".sql
- #sudo -u timer tar czf "$homeDir"/data/phpbb3_"$filename".tar.gz -C / "$homeDirTar"/data/phpbb3_"$filename".sql
- #sudo -u timer tar czf "$homeDir"/data/roundcube_"$filename".tar.gz -C / "$homeDirTar"/data/roundcube_"$filename".sql
- #sudo -u timer tar czf "$homeDir"/data/mss_forum_"$filename".tar.gz -C / "$homeDirTar"/data/mss_forum_"$filename".sql
- #sudo -u timer tar czf "$homeDir"/data/task_"$filename".tar.gz -C / "$homeDirTar"/data/task_"$filename".sql
- # clean the directory
- rm "$homeDir"/data/*.sql
- # mail the backup
- echo "Backup von dbc_blog vom $dateNow" | mutt -a "$homeDir"/data/dbc_blog_"$filename".tar.gz -s "dbc_blog $dateNow" -- anonuem@gmail.com
- #echo "Backup von dbc_blog_english vom $dateNow" | mutt -a "$homeDir"/data/dbc_blog_english_"$filename".tar.gz -s "dbc_blog_english $dateNow" anonuem@gmail.com
- #echo "Backup von roundcube vom $dateNow" | mutt -a "$homeDir"/data/roundcube_"$filename".tar.gz -s "roundcube $dateNow" anonuem@gmail.com
- # delete files older than 5 days
- find /home/timer/mysql_backup/data/* -mtime +5 -exec rm {} \;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement