cron job for mysql db backup

Posted . Visible to the public.
#!/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"
Tushar
Posted by Tushar to Tushar's deck (2020-09-11 16:59)