brianlange Posted July 6, 2010 Share Posted July 6, 2010 I'm getting a "server doesn't support command" error when I try to use the "LOCAL" keyword with load data infile. As a work around I've been using the unix secure copy command to move the file to the production server so that the LOCAL keyword does not have to be used. The problem is the file is 3 gigs and it is going to take over an hour to copy the file over. If I had the ability to run LOAD DATA LOCAL INFILE would I save time or does mysql essentially have to perform what I am doing with scp. Thanks in advance. Quote Link to comment https://forums.phpfreaks.com/topic/206940-load-data-local-infile-vs-secure-copy/ Share on other sites More sharing options...
fenway Posted July 8, 2010 Share Posted July 8, 2010 That's a permission thing. Quote Link to comment https://forums.phpfreaks.com/topic/206940-load-data-local-infile-vs-secure-copy/#findComment-1083068 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.