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
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.