5kyy8lu3 Posted August 25, 2009 Share Posted August 25, 2009 Hi. I want to load a fairly large (4MB / 85k lines) cvs file into my table. I tried using myphp admin's upload thing and it crashes and has it's own issues i don't want to mess with, i hate it. so i wish to do it the old fashioned way. (with a load infile query) problem is, i don't understand or know how the directory system works with mysql and webhosts. if i put my csv file in the public_html directory, what do i need to put in for my directory(s) for my query? i tried lots of stuff and tried using document root and etc, nothing works. any light on this subject would be awesome, much appreciated. (typos galore, sorry) Quote Link to comment Share on other sites More sharing options...
5kyy8lu3 Posted August 25, 2009 Author Share Posted August 25, 2009 ok i figured it out, i needed LOCAL in there, that was easy 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.