InfluxDB - Backup and restore - Merging 2 Databases

Hello,

I need some help:

I’ve two databases, containing the same data.

Now I want to INTEGRATE the old into the new one.
The old one is about 6months old

How can I do this?

Kind regards
Christoph Horschler

@Horschie
Hi,
You can use the INTO clause :

SELECT * INTO "your_new_database"."autogen".:MEASUREMENT FROM "your_old_database"."autogen"./.*/ GROUP BY *

Ok, sorry.

I fehlt to Seite, that the Databases are on different hosts…

Kind regards