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

I have a problem with import of 20mb sql dumo by using phpMyAdmin 3.4.1 . As you can see here there are big values for max scipt's execution time. In apache log I see the following:

[Thu Jul 14 16:28:37 2011] [error] [client] Premature end of script headers: php, referer:
[Thu Jul 14 16:28:37 2011] [debug] mod_deflate.c(615): [client] Zlib: Compressed 624 to 377 : URL /php-bin/php/mysql/phpMyAdmin341/import.php, referer:

And now I have no ideas how to fix this 500 error while import sql dump. Could you help me? TIA!

share|improve this question

use tools like bigdump for large SQL dumps.

This allows you to either upload the file on the page or upload it to the server and load it from there. Bigdump will cut the sql file in pieces and insert it bit by bit.

share|improve this answer
It's not a good way. On my another server I can upload dumps with size about 40mb and no problems. But here I resolve an internal server error (and 502 bad gateway sometimes). I also can upload dump by using a shell. But the errors described above make me worry about a server:) – dizpers Jul 14 '11 at 17:20
its probably just the settings in php.ini (max filesize) that are working against u, also uploading big files can cause timeouts on the webserver. – Goez Jul 18 '11 at 14:48

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.