# Importing data to influx DB

**URL:** <https://community.influxdata.com/t/importing-data-to-influx-db/15233>\
**Category:** Systems\
**Created:** [July 13, 2020, 4:45pm UTC](https://community.influxdata.com/t/importing-data-to-influx-db/15233 "2020-07-13T16:45:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![131712](https://avatars.discourse-cdn.com/v4/letter/1/b38774/32.png) [@131712](https://community.influxdata.com/u/131712)\
**Post date:** [July 13, 2020, 4:45pm UTC](https://community.influxdata.com/t/importing-data-to-influx-db/15233/1 "2020-07-13T16:45:42Z")

</div>

I have data in a text file as below…

```auto

 DML
 CONTEXT-DATABASE: import
 CONTEXT-RETENTION-POLICY: oneyear

FO,type=FreshOrders avg_FreshOrders=1479.0840707964599,p95_FreshOrders=2589,FreshOrders=226 1593648000000
FO,type=FreshOrders avg_FreshOrders=2242.86170212766,p95_FreshOrders=5622,FreshOrders=188 1593475200000
FO,type=FreshOrders avg_FreshOrders=1682.3375,p95_FreshOrders=2738,FreshOrders=160 1593734400000

```

I placed this text file in a folder called data inside influxDB. My requirement is to import last 3 lines of data into influx DB. I am navigating into influxDB folder `C:\Users\Administrator\Downloads\influxdb-1.8.0_windows_amd64\influxdb-1.8.0-1` and running the below command in command prompt to import it

```auto
influx -import -path=C:\Users\Administrator\Downloads\influxdb-1.8.0_windows_amd64\influxdb-1.8.0-1\data\import.txt -precision=ns

```

But data is not getting imported and getting below error. Can someone please help me in resolving this issue?

```auto
C:\Users\Administrator\Downloads\influxdb-1.8.0_windows_amd64\influxdb-1.8.0-1>influx -import -path=C:\Users\Administrator\Downloads\influxdb-1.8.0_windows_amd64\influxdb-1.8.0-1\data\import.txt -precision=s
2020/07/13 16:34:25 error: error parsing query: found DML, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found CONTEXT, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found CONTEXT, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found FO, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found FO, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
2020/07/13 16:34:25 error: error parsing query: found FO, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1 

```