Copy measurement into a different database on a different server

Dears!

I do have in influxdb v 1.8x (s4l) on 192.168.1.100 containing a measurement (P_load) with several fields
I do have a second influxdb 1.8x (test1) on 192.168.1.49

a)
I want to copy the whole measurement (P_load), with all the fields from s4l into test1. I assume very much that this needs to be some kind of “select into” statement, though I fail to do it right :frowning:

b)
would it also be possible to copy just one specific field from db s4l (measurement “P_Load”, field “data1”) into test1?

tnx for you help :slight_smile: