trying to correct data but getting attempt to write a readonly database

[jeremeyi]

I am trying to get rid of a couple of rain rate errors in my database using the guide here

https://github.com/weewx/weewx/wiki/Cleaning%20up%20old%20'bad'%20data

when I run 

echo "SELECT * FROM archive WHERE (rainRate > 10);" | sqlite3 /var/tmp/backup.sdb

it shows the two records I need to get rid of but when I run

echo "UPDATE archive SET rainRate=NULL WHERE (rainRate > 10);" | sqlite3 /var/tmp/backup.sdb

it says Error: near line 1: attempt to write a readonly database.  I have tried with sudo with the same results

 

[michael.k...@gmx.at]

What exactly did you type when you say:

>  I have tried with sudo with the same results

[jeremeyi]

sudo echo "UPDATE archive SET rainRate=NULL WHERE (rainRate > 10);" | sqlite3 /var/tmp/backup.sdb

[michael.k...@gmx.at]

Try

echo "UPDATE archive SET rainRate=NULL WHERE (rainRate > 10);" | sudo sqlite3 /var/tmp/backup.sdb

[jeremeyi]

that worked!!!  Thanks!