#4143 Export fails, generates 0-byte file without an error message

export (16)

I'm trying to export a database by first selecting it and then going to the "Export" tab.
I've exported dozens of databases literally thousands of times before, from several servers with different phpmyadmin versions and it's the first time I face this problem, but with this particular database it's 100% systematic.

When I choose "quick" and click "go", download finishes immediately (I must admit it is quick), and the downloaded file is 0 (zero) bytes in size.

I guess the problem is probably related to the fact that the amount of data in the database is relatively big. There is a table with more than 65k records. However
- that shouldn't be a problem at all
- if it is, a sensible error message should be given, saying "Database too big" and giving suggestions about how to export it: "you may want to try [...whatever...] instead".

What is unacceptable is that you get an apparently succesful download of a 0-byte file without an error message.

1 Attachments


  • sistisette

    sistisette - 2013-10-22

    And here's the error message in the server log:
    PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128204800 bytes) in /opt/lampp/phpmyadmin/export.php on line 378, referer: http://localhost/phpmyadmin/

    OMG, I can't believe phpmyadmin is trying to keep the whole database dump in memory!!!

  • Marc Delisle

    Marc Delisle - 2013-10-22

    phpMyAdmin 4.0.4 is out of date. From the ChangeLog of 4.0.6:
    "bug #4046 Exporting huge Tables causes memory-Problems"

  • Marc Delisle

    Marc Delisle - 2013-10-22
    • status: open --> out-of-date