{"id":2713,"date":"2019-05-08T11:29:55","date_gmt":"2019-05-08T15:29:55","guid":{"rendered":"https:\/\/easy-admin.ca\/?p=2713"},"modified":"2019-05-08T19:19:17","modified_gmt":"2019-05-08T23:19:17","slug":"phpmyadmin-internal-500-error-when-importing-large-database","status":"publish","type":"post","link":"https:\/\/easy-admin.ca\/index.php\/2019\/05\/08\/phpmyadmin-internal-500-error-when-importing-large-database\/","title":{"rendered":"phpMyAdmin Internal 500 error when importing large database!"},"content":{"rendered":"<h3><strong>SYSTEM NFO&#8217;s<\/strong><\/h3>\n<ul>\n<li>Fresh minimal install of <span data-id=\"sysinfo_os\">CentOS Linux 7.6.1810<\/span><\/li>\n<li>Webmin version 1.90<\/li>\n<li>ConfigServer Security &amp; Firewall 12.1<\/li>\n<li>MariaDB default webmin\/virtualmin install<\/li>\n<li>LAMP<\/li>\n<li>Phpmyadmin<\/li>\n<\/ul>\n<p>I ran into problem trying to import a large database on a fresh CENTOS 7 test lab! After setting up value in php.ini (I am running PHP version 7.0.27). I was still not able to import the database in phpmyadmin.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2715\" src=\"https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/resources-limit.png\" alt=\"\" width=\"931\" height=\"342\" srcset=\"https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/resources-limit.png 931w, https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/resources-limit-300x110.png 300w, https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/resources-limit-768x282.png 768w\" sizes=\"auto, (max-width: 931px) 100vw, 931px\" \/><\/p>\n<p>Notice the Maximum execution time is set to 120 seconds<\/p>\n<p>Even after changing this value for 240-500, 700 seconds&#8230;<br \/>\n<strong>I am still having issue importing the database!<\/strong><\/p>\n<p>Here is the fix,&#8230; you need to go in Virtualmin<\/p>\n<p>1. Select the virtual server<br \/>\n2. Navigate to -&gt; Server Configuration -&gt; Website Options<br \/>\n3. In Website and Php options navigate to Maximum Php script run time<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2716\" src=\"https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/virtualmin-fix.png\" alt=\"\" width=\"958\" height=\"812\" srcset=\"https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/virtualmin-fix.png 958w, https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/virtualmin-fix-300x254.png 300w, https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/virtualmin-fix-768x651.png 768w\" sizes=\"auto, (max-width: 958px) 100vw, 958px\" \/><\/p>\n<p>I checked &#8220;Unlimited&#8221; and hit &#8220;Save&#8221;<\/p>\n<p>Voil\u00e0, I am able to import this large database without any errors!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2717\" src=\"https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/results-phpmyadmin-import-fix.png\" alt=\"\" width=\"958\" height=\"139\" srcset=\"https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/results-phpmyadmin-import-fix.png 958w, https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/results-phpmyadmin-import-fix-300x44.png 300w, https:\/\/easy-admin.ca\/wp-content\/uploads\/2019\/05\/results-phpmyadmin-import-fix-768x111.png 768w\" sizes=\"auto, (max-width: 958px) 100vw, 958px\" \/><\/p>\n<p>For security reason I suggest that you put back the default value after your importation is finish!<\/p>\n<p><em><strong>Enjoy!<\/strong><\/em><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SYSTEM NFO&#8217;s Fresh minimal install of CentOS Linux 7.6.1810 Webmin version 1.90 ConfigServer Security &amp; Firewall 12.1 MariaDB default webmin\/virtualmin install LAMP Phpmyadmin I ran into problem trying to import a large database on a fresh CENTOS 7 test lab! After setting up value in php.ini (I am running PHP version 7.0.27). I was still &hellip; <a href=\"https:\/\/easy-admin.ca\/index.php\/2019\/05\/08\/phpmyadmin-internal-500-error-when-importing-large-database\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">phpMyAdmin Internal 500 error when importing large database!<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":2714,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"slim_seo":{"title":"phpMyAdmin Internal 500 error when importing large database! - HP Server","description":"SYSTEM NFO's Fresh minimal install of CentOS Linux 7.6.1810 Webmin version 1.90 ConfigServer Security &amp; Firewall 12.1 MariaDB default webmin\/virtualmin inst"},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2713","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts\/2713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/comments?post=2713"}],"version-history":[{"count":0,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts\/2713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/media\/2714"}],"wp:attachment":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/media?parent=2713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/categories?post=2713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/tags?post=2713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}