database backup script

backupdb.sh

#!/bin/bash

# this script makes a database backup and delete files older than 15 days
# to make script execuable use 'chmod +x backupdb.sh'

# change username, password and database for yours and modify your path if needed
mysqldump -u [username] -p[password] [database_name] > /root/backups/db_backup_`date +"%Y%m%d%H%M%S"`.sql

# change '-mtime +15' to keep more or less days (and path if needed)
find /root/backups/* -mtime +15 -exec rm {} \;