Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

Loading…

LOAD DATA (LOCAL) INFILE - pick "best" strategy at runtime #2426

Closed
robocoder opened this Issue · 5 comments

2 participants

Anthon Pang Matthieu Aubry
Anthon Pang
Collaborator

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.

Anthon Pang
Collaborator

(In [4685]) fixes #2426

Anthon Pang
Collaborator

(In [4686]) refs #2426

Anthon Pang
Collaborator

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.

Anthon Pang
Collaborator

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

Matthieu Aubry
Owner
Anthon Pang robocoder added this to the 1.5 - Piwik 1.5 milestone
Anthon Pang robocoder self-assigned this
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.