Friday, 23 August 2013

Loading data into mysql database

Loading data into mysql database

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.

No comments:

Post a Comment