tjjuggle Posted August 28, 2003 Share Posted August 28, 2003 I have a 700 meg file to insert into SQL. Rather than uploading it through PHP myadmin, I'd prefer to upload a zip of the file, unzip it and do a LOAD DATA command to mysql, however, when I do: LOAD DATA INFILE "/home/everyli/aa.txt" INTO TABLE cities; I get: LOAD DATA INFILE "/home/everyli/aa.txt" INTO TABLE cities MySQL said: Access denied for user: 'everyli@localhost' (Using password: YES) So what's up with that? Can I not load data from my account into my tables? Quote Link to comment Share on other sites More sharing options...
borfast Posted August 28, 2003 Share Posted August 28, 2003 WOW!!! 700 Mb of data? Now THAT'S a real database!! As to your question, the MySQL "LOAD DATA INFILE" documentation has this: For security reasons, when reading text files located on the server, the files must either reside in the database directory or be readable by all. Also, to use LOAD DATA INFILE on server files, you must have the FILE privilege on the server host. I'm not sure if we have the FILE privilege. Also, are the permissions on the uploaded file set to be readable by all? Quote Link to comment Share on other sites More sharing options...
tjjuggle Posted August 29, 2003 Author Share Posted August 29, 2003 It's readable by all Quote Link to comment Share on other sites More sharing options...
tjjuggle Posted August 30, 2003 Author Share Posted August 30, 2003 The techs have helped me get the data in the database, so all is well! Quote Link to comment 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.