New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Automating mysql backup and uploading to GDrive
This discussion has been closed.
Comments
You could use rclone to upload to GDrive from your bash script.
https://github.com/prasmussen/gdrive
works flawlessly. i run backups with it using a cronjob/bash script (maybe not the best but it works).
https://pastebin.com/ULeezPAf
Use ~ ~ ~ between stanzas or < p r e >
For what it's worth, you can easily pipe the dump into gzip if you're not going to bother checking return codes, and moving/sync is kind of, well, OK, sure. Still not checking return codes.
Pastebin is not loading for me, I can't see the @irm code.
In case it's a different one, I'm using this to backup my Confluence instance:
You could use automysqlbackup and rclone.
bash + GDrive/rclone
Here's code for free backup service for your database and storage/minio
https://github.com/negati-ve/docker-rclone-google-drive-cron-backup
To quote a member of this forum @codezed
He's just another necro-poster trying to draw attention to something that he threw onto GitHub some hours before