Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

  • Ben November 2016
Automating weekly or monthly database backups
  • Vote Up0Vote Down akshayakshay
    Posts: 3Sendy user

    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.

  • 1 Comment
  • Vote Up0Vote Down BenBen
    Posts: 3,606Sendy support

    Thanks for sharing. :)

This discussion has been closed.
All Discussions