Conjurer Posted November 11, 2003 Share Posted November 11, 2003 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: Quote Link to comment https://forums.phpfreaks.com/topic/1339-load-data-local-infile-not-working/ Share on other sites More sharing options...
Glish Posted November 12, 2003 Share Posted November 12, 2003 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. try to remove the LOCAL : LOAD DATA INFILE \'member.txt\' INTO TABLE member; Quote Link to comment https://forums.phpfreaks.com/topic/1339-load-data-local-infile-not-working/#findComment-4458 Share on other sites More sharing options...
Conjurer Posted November 12, 2003 Author Share Posted November 12, 2003 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? Quote Link to comment https://forums.phpfreaks.com/topic/1339-load-data-local-infile-not-working/#findComment-4460 Share on other sites More sharing options...
Glish Posted November 12, 2003 Share Posted November 12, 2003 to see if it works put the file member.txt on the root (ie c:) and try this LOAD DATA INFILE \'c:member.txt\' INTO TABLE member; Quote Link to comment https://forums.phpfreaks.com/topic/1339-load-data-local-infile-not-working/#findComment-4461 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.