Create an automatic mysql backup file and upload it on google storage.
I needed a free and automatic solution to maintain backups of my database without using my server space. So there it is.
Google Storage has a free quota of 5gb storage.
- Node 8.x
- Have MySQL installed and mysqldump on path
Install the dependencies in the project folder:
$ npm installCreate a Service Account. Save the credentials in credentials.json
$ node .0 0 * * * <NODE_PATH>/bin && <PROJECT_PATH>/index.js