if you are in the correct directory use ./wee_database ......
or specify the full path eg
/home/weewx/bin/wee_database ........

or maybe you need to use sudo


On Friday, 13 April 2018 19:47:28 UTC+3, stef 942 wrote:

> thks for yr help, i follow yr guide to cleanup database :
>
>
> pi@raspberrypi:~ $ echo "SELECT * FROM archive WHERE (rain < 0);" | 
> sqlite3 /var/tmp/backup.sdb
>
> 1523516100|1|5|29.405696969085|29.0870376875|29.0870376875|67.3666666666667|48.416|37.0|80.0|0.937794853313016|21.6687231304882|2.46063603713324|22.5|0.0|-15.3|42.5342303732686|48.416|48.416|||0.0||49.82|||||||||75.75||||||||||||||||1.0|1.0|1.0|
>
> 1523623500|1|5|29.6939319716336|29.3823375625|29.3823375625|70.4042857142857|65.12|41.7142857142857|57.5|2.13441535039209|55.6672765639842|3.13171859271503||0.0|-0.08|49.7270271335126|65.12|65.12|||0.0|67.928|||||||||72.2|||||||||||||||||0.0|0.0|0.0|
> then
> pi@raspberrypi:~ $ echo "UPDATE archive SET windSpeed=NULL WHERE (rain < 
> 0);" | sqlite3 /var/tmp/backup.sdb
> pi@raspberrypi:~ $ echo "SELECT * FROM archive WHERE (rain < 0);" | 
> sqlite3 /var/tmp/backup.sdb
>
> 1523516100|1|5|29.405696969085|29.0870376875|29.0870376875|67.3666666666667|48.416|37.0|80.0||21.6687231304882|2.46063603713324|22.5|0.0|-15.3|42.5342303732686|48.416|48.416|||0.0||49.82|||||||||75.75||||||||||||||||1.0|1.0|1.0|
>
> 1523623500|1|5|29.6939319716336|29.3823375625|29.3823375625|70.4042857142857|65.12|41.7142857142857|57.5||55.6672765639842|3.13171859271503||0.0|-0.08|49.7270271335126|65.12|65.12|||0.0|67.928|||||||||72.2|||||||||||||||||0.0|0.0|0.0|
>
> but got this :
>
> pi@raspberrypi:~ $ wee_database weewx.conf --drop-daily
> -bash: wee_database: command not found
>
>>
>>

-- 
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.
For more options, visit https://groups.google.com/d/optout.

Reply via email to