Cron Mysql Backup
The cron-mysql-backup module allows you to automate mysql backups on regular intervals
Mysql dump files will be placed in a directory of your choice
You will get confirmation emails as often as you would like
Emails will get sent anytime something goes wrong (cannot connect to database etc.)
Backups will never fill the entire disk space. The oldest ones will be removed first
Install cron-mysql-backup using npm:
$ yarn add cron-mysql-backupor$ npm install --save cron-mysql-backup
You will need a gmail account to send emails from.
I wouldn't use your personal account.
After creating an account Go to : https://www.google.com/settings/security/lesssecureapps
Set the Access for less secure apps setting to Enabled (also why you shouldn't use a personal account)
Import cron-mysql-backup and backup every hour on the hour:
const cronMysqlBackup = ;let options =directory:'./dumps'cronSchedule:" 0 * * * *"connection:host: 'localhost'user: 'make-a-read-only-user'password: 'password'database: 'database'sendTo:'email@example.com'//Notifications will be sent to this address. This can also be an array of email addressessendFrom:'firstname.lastname@example.org'sendFromPassword:'gmailPassword'sendSuccessEmailAfterXBackups:10 //Send confirmation email after every 10 backups()maxBackups: 7*24 // the maximum number of backups(a weeks worth of hourly backups);;
Use a process manager to restart your process if it ever fails https://www.npmjs.com/package/pm2
This is a quick reference to cron syntax and also shows the options supported by cron-mysql-backup.
# ┌────────────── second (optional) # │ ┌──────────── minute # │ │ ┌────────── hour # │ │ │ ┌──────── day of month # │ │ │ │ ┌────── month # │ │ │ │ │ ┌──── day of week # │ │ │ │ │ │ # │ │ │ │ │ │ # * * * * * *
|day of month||1-31|
|month||1-12 (or names)|
|day of week||0-7 (or names, 0 or 7 are sunday)|