Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
    
This one totally belongs on SF –  David Pearce Sep 10 '09 at 8:49
add comment

migrated from superuser.com Sep 10 '09 at 8:55

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

1 Answer

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.

Update
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
add comment

Your Answer

 
discard

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