How to edit max query size with PDO?

Asked Sep 28 '16 at 16:58

Active Sep 13 '17 at 12:15

Viewed 1,337 times

I have a very long query (3MB) to execute and I use PDO to do this but I have a problem: the query is too long.

I already changed the MySQL variable max_allowed_packet to 100MB but it didn't resolve the problem, so i guess it is because of PDO.

I saw this topic but MYSQL_ATTR_MAX_BUFFER_SIZE doesn't seem to exist: Fatal error: Undefined class constant 'MYSQL_ATTR_MAX_BUFFER_SIZE'

How can i resolve it ?

edited May 23 '17 at 12:33

Community

asked Sep 28 '16 at 16:58

Victor Castro

Is this one big query or a combination of multiple queries ? – Anwar Sep 28 '16 at 16:59
did you also Google that error? quite a few hits on the subject – Funk Forty Niner Sep 28 '16 at 17:02
[Docs](http://php.net/manual/en/ref.pdo-mysql.php): "This constant is not supported when compiled against mysqlnd." aka any recent version of PHP. – Sammitch Sep 28 '16 at 17:03
Zeratops it is only 1 big query. Fred-ii- i did, I found nothing – Victor Castro Sep 28 '16 at 17:07
if you're running this from local and made any changes to system files, did you restart everything? – Funk Forty Niner Sep 28 '16 at 17:13
@Fred-ii- yes i already restarted the computer – Victor Castro Sep 28 '16 at 17:22
Possible duplicate of [Undefined class constant 'MYSQL\_ATTR\_INIT\_COMMAND' with pdo](https://stackoverflow.com/questions/2424343/undefined-class-constant-mysql-attr-init-command-with-pdo) – Frank Sep 13 '17 at 11:42

0 Answers0