Daily Backup

[Ronald Merema]

Is it possible to make an automatic daily backup to dropbox?

now i have to do it manualy, and there are many days i forget to make one.

It looks to me very important, because i had last month a system crash.

Is there any way to do this? maybe in a cronjob?

[Nico Bogaert]

I use the dropbox uploader script by Andrea Fabrizi: https://andreafabrizi.it/?dropbox_uploader

It should be fairly straightforward, I think it configures itself first time you run it (can't remember exactly, but I'm not so experienced with Linux and I was able to configure it without any trouble).

I made a small bash script myself that includes this script and that I've put in a daily cronjob. It looks like this:

#!/bin/bash

NOW=$(date +"%Y.%m.%d")

sqlite3 /usr/share/nginx/www/websolarlog/database/wsl.sdb <<EOF
.timeout 20000
.backup /home/pi/wsldbbackup/wsl-$NOW.backup
EOF

$bash /home/pi/dropbox_uploader.sh upload /home/pi/wsldbbackup/wsl-$NOW.backup ./

Hope this helps. 

Nico 

[Ronald Merema]

Thanks Nico,

I have used your discription,

But i get an error when the script is executed.

Sqlite3 not found.

Is this not standard with WSL?

[Nico Bogaert]

No idea :) I suppose you are running WSL on a raspberry pi? If so, have you checked if it is installed?

Nico

[Martin Diphoorn]

Well at the moment it is not possible.

Also there is almost no development at the project. I want to improve stuff, but payed stuff has more priority.

However there is only really one important file and that is the db. So you can backup that in a cron schedule or something.