# Mqtt - node-red - influxdb

**URL:** <https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706>\
**Category:** General\
**Created:** [23 October 2020 09:00 UTC](https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706 "2020-10-23T09:00:32Z")\
**Posts on this page:** 5\
**Page:** 2

<div class="post-metadata">

**Author:** ![trombose009](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/trombose009/32/30787_2.png) [@trombose009](https://discourse.nodered.org/u/trombose009)\
**Post date:** [26 October 2020 10:54 UTC](https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706/21 "2020-10-26T10:54:13Z")

</div>

ok, thank you, understood. Yes, I know a SD-Card is not ideal. But I also think with that little amount of date and a long life quality card it should be ok. At the moment I do backup the SD-Card as an image over network to another stick which is connected to my router just for that purpose (at my still productive old system).  
I would do it the same way with the new one.

> [@Colin](#):
>
> node-red-contrib-influxd-backup

thx, i will have a look at it.

> [@Colin](#):
>
> I don't think you can change a retention policy for existing data though

oh, I see.

ok. So again, thanks for everything. Now I can do some preparation for my new system and also change the mqtt output at my sensors to json format. After that, we will see....

🙂

---

<div class="post-metadata">

**Author:** ![trombose009](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/trombose009/32/30787_2.png) [@trombose009](https://discourse.nodered.org/u/trombose009)\
**Post date:** [9 November 2020 11:16 UTC](https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706/22 "2020-11-09T11:16:19Z")

</div>

hey Collin,

I messed it up somehow. I can't do a  
select \* from temp  
anymore.  
maybe no values are written do the database.  
I recreated the database and I make  
CREATE RETENTION POLICY "one\_year" ON "sensors" DURATION 52w REPLICATION 1 DEFAULT  
to set the retention policy named "one\_year" to that database.  
the two fields (hum and temp) and the tag (room) appear but it seems to be no content 😕any idea?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [9 November 2020 11:36 UTC](https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706/23 "2020-11-09T11:36:18Z")

</div>

Remember the select \* from references a Measurement. So what is the name of the measurement you are writing to?  
If you use the influx command line program then you can Show Measurements to see what you have.

**[Edit]** If the command line shows that the measurement is called temp does the select work from there?

---

<div class="post-metadata">

**Author:** ![trombose009](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/trombose009/32/30787_2.png) [@trombose009](https://discourse.nodered.org/u/trombose009)\
**Post date:** [9 November 2020 15:53 UTC](https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706/24 "2020-11-09T15:53:47Z")

</div>

🙂 can we just forget my question? I just can't remember the name and of course it still works 😛 Sorry

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [23 November 2020 15:53 UTC](https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706/25 "2020-11-23T15:53:48Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

[Previous page](https://discourse.nodered.org/t/mqtt-node-red-influxdb/34706.md?page=1)