Delete many tables with shell command

This section covers the Meteobridge PRO, PRO2, NANO SD, Raspberry Pi and VM platforms exclusively

Moderator: Mattk

Post Reply
meteosantasusanna
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: Sun Sep 25, 2022 10:38 am

Delete many tables with shell command

Post 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
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: Delete many tables with shell command

Post 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 ;-)
Post Reply