Jump to content

LOAD DATA LOCAL INFILE not working


Conjurer

Recommended Posts

I am running version 4.0.12.NT on a Win XP Pro OS.

 

I am trying to work through the MySQL book by DuBois. When I try to run a load command I get an error.

 

From the mysql prompt I entered:

LOAD DATA LOCAL INFILE \'member.txt\' INTO TABLE member;

 

What I get is:

Error 1148: The used command is not allowed with this MySQL version.

 

Why is Load Data command not working? How can I fix this?

 

I should add that if I go to command prompt and use

mysqlimport --local sampdb member.txt

that works. The file loads.

 

:roll:

Link to comment
Share on other sites

Tried that ... now I get a different error:

 

LOAD DATA INFILE \'member.txt\' INTO TABLE member;

ERROR 1105: File \'.sampdbmember.txt\' not found (Errcode: 2)

 

Which I don\'t understand because the current directory is where the file is located. When I do a \"dir\" at the cmd prompt it returns:

Directory of C:Documents and SettingsRLaneMy DocumentsActive Web SitesLocalhostsampdb

 

and the listing of files shows the member.txt file.

 

Are we getting closer?

 

:)

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.