MYSQL database modification

[didier....@gmail.com]

Hi

I have a Belchertown skin for my meteo station

I would like to change a temperature value in the database mysql, because I have made a maintenance on the station and I have a bad value for temperature (26°C instead of 13°C)

I don't know very well how to make a simple modification on the database, could you help me?

Thanks you

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

See https://github.com/weewx/weewx/wiki/Cleaning-up-old-bad-data

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

Addendum: for mysql, use the same queries, but your favorite db browsing tool for mysql instead of the sqlite command shown in the article.

[John Smith]

phpMyAdmin is such a tool that makes changes easy to do.

[didier....@gmail.com]

many thanks for your help

[salinois]

hi,

Adminer can replace phpmyadmin.

patrick

--
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+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/weewx-user/CAGTinV5fn4yitFWr0AeuJQKpKSZPrMfM%3DQbzogh_9fMWv-1Eiw%40mail.gmail.com.

[paul.ba...@gmail.com]

Helo,

You can also use dbeaver (or dbeaver-ce) . It is also free for non commercial use.

I find it easier to install than  php-myadmin  or  adminer , and very powerfull and easy. It is certainly to powerfull for just correcting a few data, but... can do more, or less.

Personally, I prefer to use barebone mysql or sqlite3 command for most corrections, and dbeaver for data entry in large dB.

Have a good time 'til Chrismas,     Paul