Merging multiple databases

Store
1

Hi,

EDIT: nvm, merged using influx_inspect, curl and plain text files

–

First of all thanks for InfluxDB, looks promising.

Unfortunately kinda lost here.

Is it possible to merge database 2) and 3) into 1) ?
Played with SELECT INTO and backrefs but i think options are limited (hope i’m wrong)

  1. pi_sensors
    A fresh one, updated since the last 3 days.

     SHOW MEASUREMENTS: 
 	name
 	----
 	pi_sensors

 SHOW SERIES:
 	key
 	---
 	pi_sensors,device=rpiB
 	pi_sensors,device=rpiK
 	pi_sensors,device=rpiP

 SHOW FIELD KEYS:
 	fieldKey    fieldType
 	--------    ---------
 	battery     integer
 	humidity    integer
 	pressure    integer
 	temperature integer

  2. rpi11 (merge into pi_sensors as device=rpiB)
    Historical data, last 2 years from RRD

     SHOW MEASUREMENTS:
 	name
 	----
 	meas_data

 SHOW SERIES:
 	key
 	---
 	meas_data

 SHOW FIELD KEYS:
 	fieldKey    fieldType
 	--------    ---------
 	battery     integer
 	temperature integer

  3. rpiLDO (merge into pi_sensors as device=rpiK)
    Historical data, last 2 years from RRD

     SHOW MEASUREMENTS:
 	name
 	----
 	meas_data

 SHOW SERIES:
 	key
 	---
 	meas_data

 SHOW FIELD KEYS:
 	fieldKey    fieldType
 	--------    ---------
 	battery     integer
 	temperature integer
 	pressure    integer

Thanks,
Bart