I downloaded DB Browser for SQLITE windows edition on to my laptop. Stopped weeewx throughout the process. Took a copy weewx file.sdb ,opened it up in the above software and made the changes and then WRITE then to the database. Took the new copy back to weeewx ,start weeewx and wait till it adds all the new records. Once that's done I used wee_database --drop-daily and rebuild-daily so the new data is seen, then delete the NOAA reports that were affected so weeewx can create the new NOAA reports. Also take a copy of the original weewx.sdb just in case. Have used this method several times but be carefully with adding new data and don't leave blanks as weewx didn't like it. Phil
On 31 Oct 2018 13:00, "Thomas Keffer" <[email protected]> wrote: Not all versions of Linux include the utility sqlite3. You may have to install it. How to do so depends on your operating system. If you use Debian, sudo apt-get install sqlite3 will generally do it. -tk On Wed, Oct 31, 2018 at 5:41 AM Jules <[email protected]> wrote: > Hi, > > I'm seeing database is malformed errors. I've searched and found post on > how to fix this by running sqlite3 and dumping to ascii and re-importing. > > My problem is running sqlite3 ! My weewx Pi doesn't respond to sqlite3 as > a command (I thought weewx used sqlite3?). Do I install sqlite3 on my > weewx Pi or will that cause problems? > > I've tried installing the sqlite3 utilites on my windows machine. I can > make it dump my weewx.sdb to my screen but can't work out how to make it > send it back to a new file - it doesn't chcuk an error but also doesn't > create the file. > > Can anyone point me in the right direction? > > Thanks, > > > Jules > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
