author: @kawam tags:#backup_database
Cronjob CMS EBL yang digunakan untuk backup database setiap tengah malam.
# file location: /home/helpdesk/scripts/db_backup.sh
#!/bin/bash
DIR=`date +%d-%m-%y`
MDEST=~/db_backups/*
DEST=~/db_backups/$DIR
mkdir $DEST
mysqldump -u mysqladmin -p"[PASSWORD HERE]" cms-ebl-prd > dbbackup.sql
mv dbbackup.sql $DEST/
find $MDEST -type d -mtime +30 -exec rm -rf {} \;Jadwal cronjob
# dijalankan setiap tengah malam
0 0 * * * ~/scripts/db_backup.sh