# ERROR: open mydb\_data.txt: no such file or directory

**URL:** <https://community.influxdata.com/t/error-open-mydb-data-txt-no-such-file-or-directory/13514>\
**Category:** Systems\
**Created:** [March 17, 2020, 4:23pm UTC](https://community.influxdata.com/t/error-open-mydb-data-txt-no-such-file-or-directory/13514 "2020-03-17T16:23:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![xoxoboyu](https://avatars.discourse-cdn.com/v4/letter/x/f1d935/32.png) [@xoxoboyu](https://community.influxdata.com/u/xoxoboyu)\
**Post date:** [March 17, 2020, 4:23pm UTC](https://community.influxdata.com/t/error-open-mydb-data-txt-no-such-file-or-directory/13514/1 "2020-03-17T16:23:48Z")

</div>

Hi everyone,

I’m new to InfluxDB and I’m trying to import data from the .txt file to my database . I copied the data from the sample data provided by the official page. I changed the name of database in the .txt file to make it match mydb. When I use the similar command it didn’t work:

$ influx -import -path=mydb\_data.txt -precision=s -database=mydb

ERROR: open mydb\_data.txt: no such file or directory

I don’t understand the reason. Any suggestion would be helpful to me.

Thank you.

---

<div class="post-metadata">

**Author:** ![xoxoboyu](https://avatars.discourse-cdn.com/v4/letter/x/f1d935/32.png) [@xoxoboyu](https://community.influxdata.com/u/xoxoboyu)\
**Post date:** [March 17, 2020, 4:24pm UTC](https://community.influxdata.com/t/error-open-mydb-data-txt-no-such-file-or-directory/13514/2 "2020-03-17T16:24:41Z")

</div>

![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/2/22117059e243c12032347f3a85e12fbf39d8b18d.png)

Here is the data file.

---

<div class="post-metadata">

**Author:** ![Pooh](https://avatars.discourse-cdn.com/v4/letter/p/f05b48/32.png) [@Pooh](https://community.influxdata.com/u/Pooh)\
**Post date:** [March 17, 2020, 4:35pm UTC](https://community.influxdata.com/t/error-open-mydb-data-txt-no-such-file-or-directory/13514/3 "2020-03-17T16:35:32Z")

</div>

> Hi everyone,
> 
> I’m new to InfluxDB and I’m trying to import data from the .txt file to my  
> database . I copied the data from the sample data provided by the  
> official page. I changed the name of database in the .txt file to make it  
> match mydb. When I use the similar command it didn’t work:
> 
> $ influx -import -path=mydb\_data.txt -precision=s -database=mydb
> 
> ERROR: open mydb\_data.txt: no such file or directory

Try specifying an absolute path to the file.

---

<div class="post-metadata">

**Author:** ![xoxoboyu](https://avatars.discourse-cdn.com/v4/letter/x/f1d935/32.png) [@xoxoboyu](https://community.influxdata.com/u/xoxoboyu)\
**Post date:** [March 19, 2020, 7:12am UTC](https://community.influxdata.com/t/error-open-mydb-data-txt-no-such-file-or-directory/13514/4 "2020-03-19T07:12:16Z")

</div>

Thank you. I think it worked. But another problem came out.

It showed that “error”:"unable to parse ‘h2o\_feet,location=coyote\_creek water\_level=8.120,level\\ description=“between 6 and 9 feet” 1566000000\’: invalid field format.

But I did NOT change anything in the data. Is there anything wrong?

Great thanks again for your help.

 ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/0/09a55ffb5e0409cbcb5168f4bae1219b9d75f080.png)

---

<div class="post-metadata">

**Author:** ![xoxoboyu](https://avatars.discourse-cdn.com/v4/letter/x/f1d935/32.png) [@xoxoboyu](https://community.influxdata.com/u/xoxoboyu)\
**Post date:** [March 19, 2020, 7:23am UTC](https://community.influxdata.com/t/error-open-mydb-data-txt-no-such-file-or-directory/13514/5 "2020-03-19T07:23:14Z")

</div>

Thank you. I found that I misused “”. Problem solved!