Load data infile - file not found error 29 errorcode 2
Posted by:
Jeff Engel
Date: November 25, 2015 12:05PM
I have been unable to load data in to a database.
I am running Windows 7 64 bit 6 GB Ram and 603 GB free on 1 TB SSD HD
I am login to windows as the administrator.
I have created a database and created the table.
I have a tab delimited text file with all the data in it, which was generated from Excel and has a .txt extension.
I login to myql using msql -h localhost -u username -p
then enter the password.
This is the DB administrator user and password.
I load the database -> use databasename;
then -> load data infile "c:/path/filename" into table tablename;
I get error 29 HY(000) not found errorcode: 2 not such file or directory
The file has no restrictions as far as access is concerned.
I have tried different directories and different file names on luck.
I have also tried using double back slashes instead of the single forward slash, again no luck.
I have also tried running CMD.exe as a administrator but no success.
Thanks for any help!
Jeff
Subject
Written By
Posted
Load data infile - file not found error 29 errorcode 2
November 25, 2015 12:05PM
November 25, 2015 04:09PM
November 26, 2015 08:30AM
November 26, 2015 02:53PM
November 27, 2015 10:00AM
November 27, 2015 10:43PM
November 29, 2015 03:03PM
November 27, 2015 11:04AM
November 27, 2015 04:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.