1.0.7 • Published 3 years ago
backup-mysql-google-driver v1.0.7
backup-mysql-google-driver
This library will help you to perform backups of the mysql database and send them to the google drive
Custom your backup mysql and save in Google drive
This is just a bunch of encapsulated libraries to make it easier to back up the database and to store it in the cloud with more comfort and practicality. see below how you can customize.
backup
| Props | Value Type | Description | Default | Required |
|---|---|---|---|---|
| host | string | host from mysql database | - | true |
| user | string | root name mysql database | - | true |
| password | string | password mysql database | - | true |
| keep_files | number | number of backups that will be kept | 10 | false |
| folder_backups | string | name folder to create and save all backup | ./backup | false |
Cron
Use this link https://crontab.guru/ from generated a time cron running
| Props | Value Type | Description | Default | Required |
|---|---|---|---|---|
| active | bool | enable the cron | false | true |
| time | string | time the cron running | /2 * * * | true |
| timezone | string | timezone the cron | America/Sao_Paulo | true |
Google Drive
See how to configure this step below api google drive
Configure Google drive
Use this link https://developers.google.com/drive/api/v3/quickstart/nodejs to enable google drive api and get your client_id and client_secret
| Props | Value Type | Description | Default | Required |
|---|---|---|---|---|
| active | bool | enable the google drive | false | true |
| client_id | string | the client key id | - | true |
| client_secret | string | the client key secret | - | true |
| folder_id | string | the id folder | - | false |
| Props | Value Type | Description | Default | Required |
|---|---|---|---|---|
| active | bool | enable sending notification mail | false | true |
| host | string | host to send mail | - | true |
| port | number | port to send mail | - | true |
| secure | bool | secure to send mail | - | true |
| user | string | user to send mail | - | true |
| pass | string | password to send mail | - | true |
| from | string | email from send mail | - | true |
| to | string | email to send mail | - | true |
| subject | string | subject to send mail | New backup performed successfully | false |
| text | string | text to send mail | New backup performed successfully | false |
What are you doing
- Backup Database Mysql
- Dinamic login with Google driver
- Send backup file to Google Driver
- Limited backup files upload
- Delete files localy and google driver
- Limited files in Google driver
- Generated log control
- Send email alert
- Cron Dinamic
Install
yarn add backup-mysql-google-driver
Usage :
const monitor_backup = require('backup-mysql-google-driver')
monitor_backup({
backup: {
host: '',
user: '',
password: '',
database: '',
keep_files: 10,
},
cron: {
active: false,
time: `*/10 * * * *`,
timezone: `America/Sao_Paulo`,
},
google_drive: {
active: false,
client_id: '',
client_secret: '',
folder_id: '',
},
mail: {
active: false,
host: '',
port: 465,
secure: true,
user: '',
pass: '',
from: 'Name <email@email.com>',
to: '',
subject: '',
text: '',
}
})