How to export a json file from a specific Influxdb database?

Question

I have an influxdb database named metrics, I want to export it as a JSON file with its entire data.

directory = '/var/lib/influxdb/data'

I can save the list of tag keys:

influx -execute='show tag keys' -database=metrics -format=json -pretty=true > /home/ivms/metrics.json

but how can I save all tags with all values?

Hi,have you solved this problem?

Mayur
– Mayur

2019-02-04 06:51:17 +00:00
Commented Feb 4, 2019 at 6:51 — Mayur
– Mayur, Commented Feb 4, 2019 at 6:51

jimis · Accepted Answer · 2020-02-19 10:36:14Z

2

The query to return all data from all measurements in the database, including both fields and tags, would be:

SELECT * FROM /.*/

The full command line:

influx -database=metrics -format=json -pretty=true  \
    -execute='SELECT * FROM /.*/'  \
    > ~/metrics.json

NOTE:

If your database is complicated (millions of series) you might have to wait a long time for influx to actually respond, in my case it was almost 30min but it worked.

Also Make sure you give the system a large enough swap, to avoid getting OOM killed.

answered Feb 19, 2020 at 10:36

jimis

9111 gold badge11 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

leeprevost Over a year ago

This must be v1 command set. Doesn't work on current rev.

jimis Over a year ago

Indeed it's been tested on v1.8. I don't have a v2 instance to test on.

Collectives™ on Stack Overflow

How to export a json file from a specific Influxdb database?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related