backup script for mysql

simple mysqldump to file with date stamp


[root@cms]# vi scripts/backup_db.sh

#!/bin/bash
echo "dumping db"

stamp=$(date -u --date "$1" +%F)
mysqldump -u username --password=password databasename > /backups/databasename_db_backup_$stamp.sql