Internal server error after import sql dump in phpmyadmin

Posted on

Internal server error after import sql dump in phpmyadmin – Managing your servers can streamline the performance of your team by allowing them to complete complex tasks faster. Plus, it can enable them to detect problems early on before they get out of hand and compromise your business. As a result, the risk of experiencing operational setbacks is drastically lower.

But the only way to make the most of your server management is to perform it correctly. And to help you do so, this article will share nine tips on improving your server management and fix some problem about nginx, apache-2.2, , , .

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 195.64.203.162] Premature end of script headers: php, referer: http://hosting-rus.ru/mysql/phpMyAdmin341/db_import.php?db=jbs3&server=1&token=141da7abe59b0f8f53b3ce32fd6f9ead
[Thu Jul 14 16:28:37 2011] [debug] mod_deflate.c(615): [client 195.64.203.162] Zlib: Compressed 624 to 377 : URL /php-bin/php/mysql/phpMyAdmin341/import.php, referer: http://hosting-rus.ru/mysql/phpMyAdmin341/db_import.php?db=jbs3&server=1&token=141da7abe59b0f8f53b3ce32fd6f9ead

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

Solution :

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.

Leave a Reply

Your email address will not be published.