On Monday, January 18, 2021 at 6:47:09 PM UTC-8 kdch...@gmail.com wrote:
> Now when I try to copy the unpacked sdb and pick up where I left off I get
> a message that the file is not a database. I have tried a couple of
> archives from Dec and Jan. All seem to be no good. I did notice that wh
Hello,
Your error message is the one I receive when I try to use a sqlite3 file
with sqlite2 or vice et versa.
Use the command "file xxx.sdb" to find the type of sqlite [2/3] it is,
and verify which sqlite you are using.
The command "sqlite -version" return the version as expected. Be carefu
Ok the file command is showing the backups to be large ASCII files. The
backup command script is using the sqlite3 .dump command. The ascii files
are the SQL commands to rebuild the file. Here is the code.
echo 'stop the weewx daemon and wait 30 seconds'
sudo /usr/sbin/service weewx stop
ret
It's not impossible, but I'd be surprised if there are any WeeWX
installations using Sqlite 2. It was phased out nearly 5 years before the
first version of WeeWX!
On Tue, Jan 19, 2021 at 8:44 AM paul.ba...@gmail.com <
paul.bartho...@gmail.com> wrote:
> Hello,
> Your error message is the one I rec
I don't know anything, but I can google...
https://stackoverflow.com/questions/311691/importing-a-sqlite3-dump-back-into-the-database
On Tue, Jan 19, 2021 at 7:35 PM Kevin Chapman wrote:
> Ok the file command is showing the backups to be large ASCII files. The
> backup command script is using
I am in the process of industrialising my backups, but this script works
from the command line and may give you an idea of how to backup your
database without having to stop and start weewx. I will shortly have a post
up on how to do this once I have it working properly
On Wednesday, January 2
Thank you to everyone that offered advice. I was able to get my system
restored. My daily backups went sour around 12-29-2020. I guess 2020's
final blow. I was able to use the sqlite3 .read command to restore the
database and then pulled weather station data from wunderground for missing
days.
