Skip to content

Automating weekly or monthly database backups

akshayakshay
edited November 2016 in Using Sendy

If you are manually going to PhpMyAdmin or issuing making dumps to backup Sendy database regularly this is for you.

Like the same way you create cron jobs for autoresponders and schedules, you can also set cron jobs to automatically make backups of the Sendy database to your FTP.

Add this line to your crontab. make sure you replace DB_NAME, DB_USERNAME, (maybe root) and DB_PASSWORD. Also, replace BACKUP_PATH with the path on your server where you want to save the backup of Sendy every 7 days.

 * * */7 * * /usr/bin/mysqldump -u DB_USERNAME -p'DB_PASSWORD' DB_NAME > /BACKUP_PATH/$(date +%F)_full_sendy.sql

Don't set the backup path under /var/www/html, as long as you do not wish to let public download your Sendy database backups.

I hope someone finds this useful.

Comments

This discussion has been closed.

© Sendy.co 2024