MySQL Forums
Forum List  »  Newbie

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

Options: ReplyQuote




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.