Backup my SQL database

From Colettapedia
Jump to navigation Jump to search
#!/bin/sh
NOW=`date '+%Y-%m-%d__%H-%M-%S_%p'`
echo "making database backup on $NOW..."
/usr/local/mysql/bin/mysqldump -u user -ppassword -h db_host_name DatabaseName > ~/backups/db_backup_$NOW.sql