Menu

#689 (2.3.2) Compressed export returns empty file

2.3.2
fixed
Interface (555)
1
2013-06-11
2002-12-08
No

PHP 4.2.2
phpMyAdmin 2.3.2
MySQL 3.23.52
gzip 1.3.3

The compressed export ("zipped" "gzipped" "bzipped")
returns an empty file when there are many tables
selected (500+). The file is not readable by
compression application such as gzip.

The non-compressed export seems to work correctly
even with a high number of tables.

The compressed export works correctly when a low
number of tables are selected (20-30).

Thanks in advance,
Real

Discussion

  • Michal Čihař

    Michal Čihař - 2002-12-10

    Logged In: YES
    user_id=192186

    Can't reproduce this....

    Maybe the problem is in some php limits you have set, look
    into php.ini for these settings.

    I have:
    max_execution_time = 30
    memory_limit = 8M

     
  • Real Carbonneau

    Real Carbonneau - 2002-12-10
    • status: open --> open-postponed
     
  • Real Carbonneau

    Real Carbonneau - 2002-12-10

    Logged In: YES
    user_id=61368

    I confirm that the problem was with the memory_limit
    setting. I was configured at 8M also, but it seems that the
    script requires about double the memory as the exported
    files, it does not seem to be related to the number of files. I
    then tried 32M and still had the problem, it worked with 64M.
    The .sql file size was 24M before compression.

    The error is not reported to the user, but some times the zip
    file can be opened with a text viewer and the following error
    will be seen: "<br />
    <b>Fatal error</b>: Allowed memory size of 33554432
    bytes exhausted (tried to allocate 11228193 bytes) in
    <b>/var/www/html/myadmin/libraries/zip.lib.php</b> on line
    <b>111</b><br />". Other times it returns a "Cannot find
    server or DNS Error Internet Explorer" in IE6.

     
  • Michal Čihař

    Michal Čihař - 2002-12-10

    Logged In: YES
    user_id=192186

    Okay I will try add there some error reporting to user....

     
  • Michal Čihař

    Michal Čihař - 2002-12-10
    • assigned_to: nobody --> nijel
    • priority: 5 --> 3
     
  • Michal Čihař

    Michal Čihař - 2002-12-13

    Logged In: YES
    user_id=192186

    Could you please try current cvs version? It should display
    this error instead of posting it as file.

     
  • Michal Čihař

    Michal Čihař - 2002-12-18
    • summary: Compressed export returns empty file --> (2.3.2) Compressed export returns empty file
    • priority: 3 --> 1
    • status: open-postponed --> open-fixed
     
  • Michal Čihař

    Michal Čihař - 2002-12-18
    • milestone: 258465 --> 2.3.2
     
  • Michal Čihař

    Michal Čihař - 2003-02-03
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
MongoDB Logo MongoDB