Dropping a column is easy enough. Consult your Mariadb documentation, but it should be something like (NOT TESTED)
*ALTER TABLE archive DROP COLUMN leafWet2;* *DROP TABLE archive_day_leaf;* WeeWX only stores data that appear as columns in the database, so this won't cause a problem as far as it is concerned. However, I think you'll be disappointed in how little space it saves. Much of the space is taken up by indexes. -tk On Thu, Feb 13, 2020 at 4:27 PM ed100 <[email protected]> wrote: > What would happen if I edit the wview_extended.schema, drop the current > weewx databast and just open up a fresh database using new schema with the > fields I want to use, of course including the required ones? > > In part I am trying to understand how things work. > > > > On Thursday, February 13, 2020 at 4:54:46 PM UTC-6, ed100 wrote: >> >> I have the Belchertown skin with MQTT running nicely after some serious >> help from folks here. >> There are a bunch of fields in the weewx mariadb database that I will >> never use. I did some searching to how to do this but didn't find out how. >> I don't want to damage things, just clean up unnecessary fields. (old >> habits...) >> I did grab the extraTemp1 and use it to show the cpu temp on the weewx >> raspberry. >> >> Thanks >> > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/b97b1926-70f7-46d9-8d84-5db354556066%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/b97b1926-70f7-46d9-8d84-5db354556066%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBZUJPBVzdoo6MjaUJk%3DXfMUU9EkHKng70WQfAQ5KRXLw%40mail.gmail.com.
