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) Link to comment https://forums.phpfreaks.com/topic/171748-solved-need-help-figuring-out-document-root-for-load-infile/ 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 Link to comment https://forums.phpfreaks.com/topic/171748-solved-need-help-figuring-out-document-root-for-load-infile/#findComment-905606 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.