@robocoder opened this Issue on May 13th 2011 Contributor

The current algorithm is to first attempt "LOCAL", and then "REMOTE".

The new strategy is to look at the host name, and if it appears local, try LOAD DATA LOCAL INFILE first. Conversely, if it appears to be remote, try LOCAL DATA INFILE first. Then fallback to the other case.

@robocoder commented on May 13th 2011 Contributor

(In [4685]) fixes #2426

@robocoder commented on May 13th 2011 Contributor

(In [4686]) refs #2426

@robocoder commented on May 13th 2011 Contributor

This fixes the issue reported by Monica/Anton on the forum. Windows Server 2008, php 5.3.2 --with-pdo-mysql=mysqlnd, adapter=PDO_MYSQL, MySql 5.1.45, and "local infile = on", Piwik_Exec('LOAD DATA LOCAL INFILE ...') throws an exception ($e->getMessage() is empty), and subsequent queries (ie fallback) all fail.

@robocoder commented on May 13th 2011 Contributor

(In [4687]) refs #2426 - can skip LOCAL under some conditions

@mattab commented on September 23rd 2013 Member
This Issue was closed on September 23rd 2013
Powered by GitHub Issue Mirror