Export of 37000 record table

[Former user]

Originally reported on Google Code with ID 78

What steps will reproduce the problem?
1. Click export on 37000 record database


What is the expected output? What do you see instead?
Broswer error message - page not found

What version of the product are you using? On what operating system?
1.9.1

Please provide any additional information below.

Export of 37000 record table fails. 12000 record table in same database works okay

Reported by michael.d.hornsby on 2012-01-07 08:30:28

[Dane Iracleous]

Are you sure you aren't getting a PHP timeout error? Like "x amount of y memory exhausted"?
In any case, you should increase your memory and maximum execution time settings in
php.ini. phpLiteAdmin should be able to export that many records, but your PHP configuration
might be preventing it.

Reported by diracleo on 2012-10-29 06:10:27

[dreadnaut]

This might also be because the database object returns an array of arrays (Database::selectArray,
line ~920) trying to allocate memory for the whole table of results.

We could return an iterable object, instead, and we should not hit memory limits.

Reported by dreadnaut on 2012-11-22 19:30:06

[Christopher Kramer]

Yeah, right. Loading thousands of rows into memory seems to be a bad idea and likely
the root cause for this problem.

Reported by crazy4chrissi on 2012-11-22 22:42:46 - Status changed: Accepted

[Christopher Kramer]

Related to issue #209.

Reported by crazy4chrissi on 2014-01-15 10:09:30 - Labels added: Target-1.9.6

[Kevin Wojniak]

I'm running into this same issue. Have a table with 39k rows.

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 78 bytes) in phpliteadmin.php on line 5417

[phpLiteAdmin]

Export (CSV and SQL) of huge tables is now possible because the export won't fetch the whole table in memory anymore but iterate over the resultset. This fixes issue #78.

→ <<cset 6947ecc44da1>>

[Christopher Kramer]

I just fixed this. I successfully exported a ~ 16 Million rows table to CSV and SQL. Tried opening the CSV in Excel :D It won't read that many rows...

Get the current development version here to try it: http://www.phpliteadmin.org/phpliteadmin-dev.zip