Backup my SQL database
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