Page 1 of 1

Delete many tables with shell command

Posted: Tue Sep 17, 2024 8:19 pm
by meteosantasusanna
Hello,
I need to delete many tables (from sensors that still not connected to my station) from my meteobridge database on RPI. Are the any way to delete it with an shell comand so to delete the tables manually is a lot of time and work.

Thanks in advance

Re: Delete many tables with shell command

Posted: Thu Sep 19, 2024 2:39 pm
by admin
You can login and get access to the database via "sqlite3 /tmp/mnt/dbase". sqlite3 docs tell you how to operate there. You will find data for a specific sensor in different time resolutions (all, year, month, day, hour, min). By deleting just some of those you will make the system inconsistent. Not sure it is really sparing time ...

I think it is obvious, by doing so you are on your own whatever happens to your system ;-)