Last Updated: February 25, 2016
·
598
· thinkinglemur

Load Data Infile Permissions Quickfix

#php
#mysql

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.

#php
#mysql

Written by Donnie Bachan

Say Thanks
Respond

Related protips

How to convert string to integer (PHP & MySQL)

111.8K
2

Connecting to a MSSQL Server/Database With PHP on Ubuntu/Debian

69.09K
2

Installing PHP 5.4, MySQL, PhpMyAdmin and Nginx on Mac using Homebrew

50.12K
15

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Php Authors
projectcleverweb
516.6K
#php
#javascript
#css
brandonbeeks
373.1K
#php
#javascript
#css
jvinceso
310.9K
#php
#ASP
#JavaScript
hnordt
251.9K
#php
#laravel
#CoffeeScript
rmcdaniel
244.2K
#php
#JavaScript
#Open Source
Related Tags
#php
#mysql
Sponsored by
#native_company#
#native_desc#
#native_cta#
Filed Under
PHP tips that still matter
MySQL tips that still default
Awesome Job
See All Jobs
Post a job for only $299
Did you know?

PHP applications still send a browser full of JavaScript. Hardening the server does not inventory the payment, analytics, and plugin scripts that run after the HTML is delivered.

Security insights from Cside

Thanks to our sponsor
Sponsored by #native_company# — Learn More
#native_title# #native_desc#
#native_cta#