WordpressMysqlBackupJob.sh

echo "starting WordPressMysqlBackupJob..."
 
WP_DB=$SCHEDULER_PARAM_WP_DB
WP_USER=$SCHEDULER_PARAM_WP_USER
WP_PASS=$SCHEDULER_PARAM_WP_PASS
BACKUP_DIR=$SCHEDULER_PARAM_BACKUP_DIR
 
echo "WP_DB: $WP_DB"
echo "BACKUP_DIR: $BAKCUP_DIR"
 
TIMESTAMP=`date '+%Y%m%d%H%M%S'`
FILENAME="${WP_DB}_${TIMESTAMP}.sql"
 
echo "FILENAME: $FILENAME"
 
mysqldump -u $WP_USER -p$WP_PASS $WP_DB > $BACKUP_DIR/$FILENAME
 
echo "WordpressMysqlBackupJob completed."
 
exit 0