Internal Server Error Phpmyadmin Import
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this phpmyadmin error in processing request error code 500 site About Us Learn more about Stack Overflow the company Business Learn phpmyadmin 500 internal server error more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Internal server error while importing sql file? up vote 0 down vote favorite I am importing an SQL file and it shows me an error like this Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator at admin@example.com to inform them of the time this error occurred, and the actions you performed just before this error. More information about this error may be available in the server error log. I have already make changes in php.ini file, which are listed below MAX_UPLAOD_SIZE = 20M MAX_EXECUTION_TIME = 600 POST_MAX_SIZE = 20M How to resolve this? php mysql sql apache wampserver share|improve this question edited Dec 11 '13 at 11:47 Bart Friederichs 20.2k54387 asked Dec 11 '13 at 11:45 Ghanshyam Katariya 337417 Check your server logs. –Bart Friederichs Dec 11 '13 at 11:46 2 Give me solution as soon as. -1 to that. –Shankar Damodaran Dec 11 '13 at 11:46 share the code what u have written. –Suresh Kamrushi Dec 11 '13 at 11:48 I am importing a big sql file in phpmyadmin. Sql file size is more than 40 mb. I set value of max_uplaod_size upto 60mb. but still its not working –Ghanshyam Katariya Dec 11 '13 at 11:59 Make sure POST_MAX_SIZE is also set accordingly. That, and you are consistently misspelling MAX_UPLOAD_SIZE. –Bart Friederichs Dec 11 '13 at 12:09 add a comment| 2 Answers 2 active oldest votes up vote 0
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ 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: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Internal server error after import sql dump in phpmyadmin up vote 0 down vote favorite I have a http://stackoverflow.com/questions/20518280/internal-server-error-while-importing-sql-file 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 http://serverfault.com/questions/290279/internal-server-error-after-import-sql-dump-in-phpmyadmin error while import sql dump. Could you help me? TIA! nginx apache-2.2 share|improve this question asked Jul 14 '11 at 10:44 dizpers 1065 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote 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 answered Jul 14 '11 at 12:43 Goez 1,305510 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 1 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 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy po
Sign in Pricing Blog Support Search GitHub This repository Watch 164 Star 1,882 Fork 1,092 phpmyadmin/phpmyadmin Code Issues 185 Pull requests 14 Projects 0 Wiki Pulse Graphs New issue 4.6.0: Export generating error 500 (was https://github.com/phpmyadmin/phpmyadmin/issues/12159 working in 4.5.5.1) #12159 Closed beat opened this Issue Apr 5, 2016 · 11 comments Projects None yet Labels bug Milestone 4.6.1 Assignees nijel 4 participants beat commented Apr 5, 2016 Steps to reproduce Go to browse a table Click "Export" tab (or select table and with selected do "Export") Btw: When clicking "Server: localhost" in the breadcrumbs gives same error 500. Expected behaviour A selection internal server of export formats should appear Actual behaviour Erorr 500 is displayed (and looking at response, it has valid JSON with success:true and message having the correct reply, however HTTP return code is 500 instead of 200. Server configuration Operating system: Ubuntu 14.04.1 Web server: Apache 2.4 Database: MySQL 5.5.47 PHP version: 5.5 phpMyAdmin version: 4.6.0 (works in 4.5.5.1) Client configuration Browser: FIrefox Linux (latest) Operating system: Ubuntu 12.04 I searched through internal server error the issues, but didn't find an open or closed bug describing this. phpMyAdmin member nijel commented Apr 6, 2016 Can you find some error in the PHP / webserver logs? profhun commented Apr 6, 2016 Try to remove folders inside phpmyadmin: js libraries locale Then re-extract from the original zip package. I was the same error when i just copied the new version into the existing phpmyadmin installation. The main problem is: inside libraries/plugins/import/ dir all files renamed, and some autoload can't find the new file, just the old ones. nijel added the question label Apr 6, 2016 beat commented Apr 6, 2016 Here we go with the error: PHP Fatal error: Class 'PMA\\libraries\\plugins\\export\\ExportOds.class' not found in /home/xx/public_html/phpmyadmin/libraries/plugin_interface.lib.php on line 88, referer: https://www.xx.com/phpmyadmin/tbl_export.php?db=mydb&table=MY_VIEW_TABLE&token=aaacf270c09e90f4e4ff084fcf98e512&single_table=true The version 4.6 was installed by upgrade from 4.5.5.1 using VirtualMin script installer. So I guess with a files overwrite. Will check with the original 4.6 zip. nijel added bug and removed question labels Apr 6, 2016 nijel added this to the 4.6.1 milestone Apr 6, 2016 nijel self-assigned this Apr 6, 2016 phpMyAdmin member nijel commented Apr 6, 2016 Okay, your bug is definitely caused by not removing old files. However I think we should be able to cope with such mess and avoid crashing... ð