Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So here's the thing. On completely different hosts, installations, operating systems and versions of MySQL and PHP (and phpMyAdmin) (but always on a host I'm visiting over the Internet), I've found an interesting situation:

When I try to export a database table (MyISAM or InnoDB) which has "a lot" of data in it, using compression (gzip, zip, it doesn't matter), the file generated isn't complete.

I've put "a lot" in quotes, because it ranges from 1 000 rows to 30 000 rows, depending on the platform. It seems the actual amount is irrelevant.

I have worked around this problem by running mysqldump on the command line and then compressing the output, but I wanted to hear from the community whether this is a known issue, or if it has something to do with the crap bandwidth we have in South Africa, which was recently beaten by a carrier pigeon.

share|improve this question

migrated from Sep 10 '09 at 8:55

This question came from our site for computer enthusiasts and power users.

This one totally belongs on SF – Josh Hunt Sep 10 '09 at 8:49
up vote 4 down vote accepted

My guess is that it's a script time-out issue with phpMyAdmin, or perhaps a file-size limitation of the underlying webserver.

On a script-by-script bases, you can add set_time_limit(0); at he top and it will override the PHP settings for script timeout to infinite. Any value other than 0 will set it for that many seconds.

share|improve this answer
I thought it was file size limit, but it turned out not to be the case. I'm also inclined to think it's a timeout. – user3914 Sep 10 '09 at 11:27
Ok, I'm accepting this answer. No one else seems to have any input. – user3914 Sep 11 '09 at 12:56
hopefully it's right :) – warren Sep 12 '09 at 6:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.