Load Data Infile Permissions Quickfix
Attempting to use the sql command LOAD DATA INFILE from php script when the script (client) is on a different machine to the mysql server and the user does not have full permissions use the: LOAD DATA LOCAL INFILE. This will allow the file to be successfully imported into the database.
Written by Donnie Bachan
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Php
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#