|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #67475 load data local infile fails with pdo_mysql, works with mysqli
Submitted: 2014-06-19 09:13 UTC Modified: 2020-12-11 10:42 UTC
Avg. Score:4.3 ± 0.9
Reproduced:3 of 3 (100.0%)
Same Version:3 (100.0%)
Same OS:1 (33.3%)
From: jaroslav at thinline dot cz Assigned:
Status: Duplicate Package: PDO MySQL
PHP Version: 5.5.13 OS: Linux
Private report: No CVE-ID: None
 [2014-06-19 09:13 UTC] jaroslav at thinline dot cz
Using SQL statement LOAD DATA LOCAL INFILE with PDO doesn't work, an error "SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version" is returned even with PDO::MYSQL_ATTR_LOCAL_INFILE set to 1 in constructor.

When trying the same with mysqli extension however, everything is executed correctly and test table is filled with data.

PHP is running on Debian Wheezy, using package from

Test script:
// Non-functional with PDO
try {
  $con = new PDO("mysql:host=;dbname=testdb", "user", "pass",
                 array(PDO::MYSQL_ATTR_LOCAL_INFILE => 1));
  $con->exec('load data local infile \'test.csv\' into table testtable fields terminated by \',\' enclosed by \'"\' escaped by \'"\'');
} catch (PDOException $e) {
  echo $e->getMessage();

//Functional with mysqli
$con = mysqli_init();
mysqli_options($con, MYSQLI_OPT_LOCAL_INFILE, true);
mysqli_real_connect($con, '', 'user', 'pass', 'testdb');
mysqli_query($con, 'load data local infile \'test.csv\' into table testtable fields terminated by \',\' enclosed by \'"\' escaped by \'"\'');


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2015-02-03 20:13 UTC] phpbugs2012 at joern dot heissler dot de
Duplicate of
 [2020-12-11 10:42 UTC]
-Status: Open +Status: Duplicate
 [2020-12-11 10:42 UTC]
Duplicate of bug #62889 per above comment.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Jul 20 01:01:29 2024 UTC