#!/bin/bash

USER="root"
PASSWORD="example"
DATABASE_NAME="openstack_mysql"
BACKUP_DIR="/home/ubuntu/mysql-backup"
TIME_STAMP=$(date +%s)
BACKUP_PATH="${BACKUP_DIR}/${DATABASE_NAME}_${TIME_STAMP}.sql"

ALL_MYSQL_FILES=$(ls ${BACKUP_DIR} | grep "openstack_mysql_[0-9]*.sql")
for FILE in ${ALL_MYSQL_FILES}; do
    timestamp=$(echo ${FILE} | grep -o "[0-9]*")
    if [ ${timestamp} -lt ${TIME_STAMP} ]; then
	sudo rm "${BACKUP_DIR}/${FILE}"
    fi
done



mysqldump --user="${USER}" --password="${PASSWORD}" --all-databases > "${BACKUP_PATH}"