HowTo Backup MySQL Database Automatically via Cron Jobs

/usr/bin/mysqldump -h localhost -u USERNAME -pPASSWORD DB-NAME | gzip > /backup/mysql/DB-NAME_$(date +\%Y-\%m-\%d).sql.gz	

Leave a Reply

Your email address will not be published. Required fields are marked *