Using Ubuntu Server 14.04 x64 / PHP 5.5.9-1ubuntu4 (cli) w/ FPM / MySQL InnoDB version 5.5.35
Incredibly frustrated with what was supposed to be a minor issue. Basically, I'm being forced to recompile PHP from source (something I've never done nor had to do) to be able to execute a LOAD DATA query from PHP - something as simple as loading a CSV into a MySQL database programmatically which I mistakenly perceived to be mundane and everyday. (My previous question: https://stackoverflow.com/questions/24618135/mysql-still-cant-load-data-local-infile-path-to-file-txt-into-table-test-fi).
That being said... I have installed PHP-FPM and though there are countless tutorials on how to install any variation of PHP or PHP-FPM in Linux, the river starts to run dry when you have to properly remove your current installation and recompile PHP from source. I started in the direction of compiling my own from a tutorial when I received the following error (amongst hundreds of lines of verbose output):
configure: error: utf8_mime2text() has new signature, but U8T_CANONICAL is missing.
I needed to remove PHP and recompile with support for PDO::MYSQL_ATTR_LOCAL_INFILE => true? I ran the remove script for everything I installed with PHP and it looked like this:
sudo apt-get remove php5-mysql php5-curl php5-gd php5-intl php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-ming php5-ps php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5-xsl php5-fpm
So I think PHP is properly removed...
Also, it seems that I need other PHP extensions (such as mcrypt, php-gd, and others needed for WordPress/Magento type apps). Do these have to be compiled with them as well at the same time? If I come across another extension in the future, I assume that means I have to remove PHP again and recompile. This should be fun.