Question

1

Loading data into mysql database

rated 0 times [ 1] [ 0] / answers: 1 / hits: 3849 / 2 Years ago, thu, october 20, 2022, 11:52:18

I have a text file which i would want to load into mysql database on Ubuntu server 12.04 LTS. I have entered the data into the file trey.txt and i moved the file to /tmp directory. When i move to the db, and enter the command

LOAD DATA

INFILE '/tmp/trey.txt'

into table arp_table

columns terminated by '|';

the output is

 ERROR 13(HY000):Can't get stat of '/tmp/trey.txt'(Errcode: 2)

How should i modify to enter these details. And can i run this from command line as a cron job.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

epypian

Add To Favorites

Follow

Total Points: 130

Total Questions: 111

Total Answers: 113

Location: Romania

Member since Mon, Jun 6, 2022

2 Years ago

epypian questions

1 How do I exit the Gui, and return to a plain command line shell?

Fri, Dec 30, 22, 04:22, 1 Year ago

1 Dual boot with Windows 10, Grub no longer working

Sat, Jul 31, 21, 18:35, 3 Years ago

1 I can't resize my root partition

Sun, Oct 24, 21, 23:28, 3 Years ago

1 Who develops and maintains Ubuntu's "Network Manager"?

Sun, Dec 26, 21, 12:08, 2 Years ago

1 2nd screen detected but black (Xubuntu 20.04, Nvidia gpu)

Tue, May 9, 23, 21:23, 1 Year ago

View All

answered 2 Years ago ticeate · Accepted Answer

The problem i was having was that for security reasons, local data offloading is disabled by default , and for the file to be read into the database, it must be enabled by starting mysql using

mysql -uroot -ppassword --local-infile database

This will solve the problem and you can insert from a text file.