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 retn_code=$? if [ $retn_code -ne 0 ]; then exit 7 fi sleep 30s echo 'dump sqlite3 database' echo '.dump' | sqlite3 $WEEWX_DB | gzip -c > $DUMP_FILE echo 'restart the weewx daemon' sudo /usr/sbin/service weewx start I am not good with sqlite. I have read a few different sites talking about how to read a dump file into a database. So far I am not having luck recovering my database. If anyone has a site they trust or have a quick command for recovering sqlite dump files it would be much appreciated. So far when I run sqlite3 <DB> and then .read <dump file> It seems to run but in about 30 seconds ends at the prompt with no errors on screen and the database file is empty. Thank you all for your input and time. On Monday, January 18, 2021 at 9:20:59 PM UTC-6 vince wrote: > 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 when >> I reinstalled weewx it is now version 4.3.0. Could I be dealing with a >> system version mismatch in the file or is there something wrong with my >> backup process. >> > > Very likely a backup process issue, although the steps you mentioned > looked good to me. > > We'd need to see some actual logs or terminal errors to know for certain > what you're actually seeing. > > I guess what I'd do is: > > - grab a recent backup, copy it to a scratch directory > - uncompress it to a .sdb file > - run 'file' against the .sdb file > - If it shows up as a sqlite3 db, then you can validate it with the > sqlite3 utility. > > > Good output looks like.... > > # file weewx.sdb > weewx.sdb: SQLite 3.x database, last written using SQLite version 3026000 > > # echo "pragma integrity_check" | sqlite3 weewx.sdb > ok > > > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/52eb0a6c-a7d1-4fcf-9f22-717f6bfe22fdn%40googlegroups.com.
