Migrate measurements from one influxdb to another



i want to migrate a bunch of measurements from our influx testing envoirenment to our productive env.
I already fiddled around with a curl like:

curl -G ‘test:8086/query?’; --data-urlencode “db=dbname” --data-urlencode “q=SELECT * FROM series_name” > series.json

and did a XPOST

curl -XPOST -d @series.jsonhttps://localhost:8086/write?db=import

This runs through my whole file but stops with:

}]}]}’: missing tag value"}

My Import DB is still empty.

So how can i migrate this stuff?


1 Like


The reason this doesn’t work is because the data isn’t in line protocol, which is the format InfluxDB expects. You might try using the backup and restore feature rather than moving the data manually with files. Otherwise, you have to deal with the format of the data.