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 careful that "sqlite" (no 2 neither3) is sometimes associated with one or the other. There is not much difference between them, except that they store the data in different format that are 100% incompatible!. Much better to always call the version explicitly. In the (very improbable) case that your sdb file is in the wrong format, you can easily change it to the right one by dumping the data using the corresponding version of sqlite ( .output MyData.sql <cr> .dump) to write the data in readable format, then reading back with the correct sqlite (Most probably sqlite3 < MyData.sql). Regards, Paul
Le Tuesday, January 19, 2021 à 4:20:59 AM UTC+1, vince a écrit : > 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/2357efa0-741b-41bd-9724-5080eb29a73cn%40googlegroups.com.
