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.