I tried to side load to restore data to a database that already exists using instructions from:
I am getting following error:
[root@rich-tig-01-tv opt]# influx
Connected to http://localhost:8086 version 1.7.6
InfluxDB shell version: 1.7.6
Enter an InfluxQL query
show databases
name: databases
name
_internal
telegraf
HMSTG
telegraf_win
jmeter
hostingmetrics
use hostingmetrics
Using database hostingmetrics
SELECT * INTO HMSTG…:MEASUREMENT FROM /.*/ GROUP BY *
ERR: no data received
hostingmetrics is a database that i am trying to migrate from a different server. The restore on the new server with the database name hostingmetrics was successfull.
However when i try to sideload data using “SELECT * INTO” to the existing database “HMSTG” fails with above error.
Please help.