Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Closed
robocoder opened this issue May 13, 2011 · 5 comments
Closed

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

robocoder opened this issue May 13, 2011 · 5 comments
Assignees
@robocoder
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
1.5

Comments

@robocoder
Copy link
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
Copy link
Contributor Author

(In [4685]) fixes #2426

@robocoder
Copy link
Contributor Author

(In [4686]) refs #2426

@robocoder
Copy link
Contributor Author

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
Copy link
Contributor Author

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

@mattab
Copy link
Member

mattab commented Sep 23, 2013

see this FAQ load data in file piwik

@robocoder robocoder added this to the 1.5 - Piwik 1.5 milestone Jul 8, 2014
@robocoder robocoder self-assigned this Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@robocoder robocoder

Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Milestone
1.5
Development

No branches or pull requests
2 participants
@mattab @robocoder