It looks like you're new here. If you want to get involved, click one of these buttons!
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.
Thanks for sharing. :)