I’m trying to put together a script that will automatically backup my Everdo database as a .JSON and send it to my backup hard drive, using rsync on Linux. I prefer JSON to CSV so that I can easily import it in case of recovery.
I think I can do this by copying the database file and moving it to my HD. But my question is which database file should I use under user/config/everdo ?
Does anyone know how I can replace the old backup with the new one?
I’ve got my script 99.9% done. I’ll share it when it’s finished.
The only missing step is to delete the old backup. This would be easy to do if the backup had a static name, but alas, we’re a dilligent bunch here and want to keep the time and date in the filename.
Thanks everybody but I’ve finished this project. I have one unified backup script that backs up Everdo, Firefox bookmarks, and then copies the home directory to my external hard drive.
For Everdo this is what I have:
`#delete old Everdo backups
cd Documents/Backups
rm everdo_backup_*
cd
#create Timestamp
TIMESTAMP=$(date +%F_%T | tr ':' '-')
#backup Everdo
sqlite3 /home/user/.config/everdo/db ".backup '/home/user/Documents/Backups/everdo_backup_$TIMESTAMP.sqlite'"`
The only flaw could be that I delete all Everdo backups first, which could leave me back-up-less if the next backup fails. But, I don’t think that’s an issue since I must have access to the computer to run this, so I can most definitely still create a new backup.