Restore failed with ERR: no data received

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.