cron job for mysql db backup
#!/bin/bash
PASS="$(cat /root/etc/mysqlpass)"
$DBNMAE="website_db"
mysqldump -u root -p$PASS $DBNMAE | gzip > "/home/ubuntu/db_backup/website_db_`date '+%Y-%m-%d'`.sql.gz"
#!/bin/bash
PASS="$(cat /root/etc/mysqlpass)"
$DBNMAE="website_db"
mysqldump -u root -p$PASS $DBNMAE | gzip > "/home/ubuntu/db_backup/website_db_`date '+%Y-%m-%d'`.sql.gz"