# Copy measurement into a different database on a different server

**URL:** <https://community.influxdata.com/t/copy-measurement-into-a-different-database-on-a-different-server/33258>\
**Category:** Systems\
**Tags:** influxdb\
**Created:** [February 18, 2024, 8:00pm UTC](https://community.influxdata.com/t/copy-measurement-into-a-different-database-on-a-different-server/33258 "2024-02-18T20:00:09Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hugo](https://avatars.discourse-cdn.com/v4/letter/h/b38774/32.png) [@Hugo](https://community.influxdata.com/u/Hugo)\
**Post date:** [February 18, 2024, 8:00pm UTC](https://community.influxdata.com/t/copy-measurement-into-a-different-database-on-a-different-server/33258/1 "2024-02-18T20:00:09Z")

</div>

Dears!

I do have in influxdb v 1.8x (s4l) on [192.168.1.100](https://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](https://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 ☹

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 🙂