How to get big data from mysql in php?

Question

How to get big data from mysql in php? I tried, but I get line 1048576 , and my line is longer.

Answer 1

Okay, so thanks to Pablo Jimenez, it was fast.

The Pdo buffer is really too small, so I was able to get my data.

$pdo = new PDO( $dsn, $username, $password, array(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE => 2097152) 

);