MySQL Forums
Forum List  »  Newbie

Re: Can't LOAD DATA INFILE please help
Posted by: Niti
Date: August 13, 2004 10:35AM

Hi Marnik,

This seems like you are not setup as the user on the DB on which you are trying to load a file. So go to User Administration of the MySQL Control Center {if that is the GUI that you are using}, and setup an account there for whatever user and passwd that you are trying to connect with..

I am pretty new to MySQL as well.. and I was facing the same problem last week, and it took me a while to get it.. but here is a command that I used.. if this helps in any way..

LOAD DATA INFILE '/dir/dir/your_file.txt' INTO TABLE {tableName};

Also before you use this command make sure you are using the right DB..
command for that is:

use {Your_DB_Name};

and to be double sure, you can see the tables in that DB:

show tables;

hope this helps...

good luck -

Options: ReplyQuote


Subject
Written By
Posted
August 13, 2004 05:31AM
Re: Can't LOAD DATA INFILE please help
August 13, 2004 10:35AM


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.