{"id":38808,"date":"2018-03-01T12:16:23","date_gmt":"2018-03-01T18:16:23","guid":{"rendered":"http:\/\/webirix.com\/?p=38808"},"modified":"2018-03-01T12:18:14","modified_gmt":"2018-03-01T18:18:14","slug":"aumentar-tamano-max-importacion-phpmyadmin-xampp","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/aumentar-tamano-max-importacion-phpmyadmin-xampp\/","title":{"rendered":"How to increase max size import in PhpMyAdmin in XAMPP"},"content":{"rendered":"<h2 class=\"title\">Increase size max. import in PhpMyAdmin<\/h2>\n<p>&nbsp;<\/p>\n<p>To increase the maximum import size in PhpMyAdmin, you have to increase the maximum file upload size in the\u00a0<span class=\"skimlinks-unlinked\">php.ini<\/span>. This is done by editing the following parameters in the phpmyadmin:<\/p>\n<p>upload_max_filesize (Default 2M)<br \/>\nmemory_limit (Default 16M) (In case you don&#039;t have the time to process such a large file)<br \/>\npost_max_size (Default 8M)<\/p>\n<p>&nbsp;<\/p>\n<p>To do this we follow these steps:<\/p>\n<ol>\n<li>In the XAMPP Control panel we can find the Apache configuration. We click on the button and followed by php.ini as the image shows us.<\/li>\n<\/ol>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/phpini.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38809 size-full\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/phpini.png\" alt=\"\" width=\"667\" height=\"430\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/phpini.png 667w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/phpini-300x193.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/phpini-600x387.png 600w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>2 In this file we are going to find the parameters to modify<\/p>\n<p>According to the needs of the Administrator we can modify these figures.<\/p>\n<p><strong>UPLOADS MAX FILE<\/strong><\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/upload_max_filesize.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-38812 size-full\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/upload_max_filesize.png\" alt=\"\" width=\"856\" height=\"601\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/upload_max_filesize.png 856w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/upload_max_filesize-300x211.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/upload_max_filesize-768x539.png 768w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/upload_max_filesize-600x421.png 600w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>MEMORY LIMIT<\/strong><\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/memory.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38811\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/memory.png\" alt=\"\" width=\"853\" height=\"603\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/memory.png 853w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/memory-300x212.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/memory-768x543.png 768w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/memory-600x424.png 600w\" sizes=\"auto, (max-width: 853px) 100vw, 853px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>POST MAX SIZE<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/post.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-38810\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/post.png\" alt=\"\" width=\"852\" height=\"598\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/post.png 852w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/post-300x211.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/post-768x539.png 768w, https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/post-600x421.png 600w\" sizes=\"auto, (max-width: 852px) 100vw, 852px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Once the changes are made, don&#039;t forget to restart the apache service.<\/p>","protected":false},"excerpt":{"rendered":"<p>Increase size max. import file in PhpMyAdmin To increase the maximum import size in PhpMyAdmin, you have to increase the maximum upload size of files in php.ini. This is done by editing the following parameters in the phpmyadmin: upload_max_filesize (Default 2M) memory_limit (Default 16M) (In case you do not have the time to ...<\/p>","protected":false},"author":25,"featured_media":38813,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2025,1947],"tags":[],"class_list":["post-38808","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-servidores","category-preguntas-frecuentes-categoria"],"jetpack_featured_media_url":"https:\/\/webirix.com\/wp-content\/uploads\/2018\/03\/xampp-logo.png","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=38808"}],"version-history":[{"count":4,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38808\/revisions"}],"predecessor-version":[{"id":38817,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38808\/revisions\/38817"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/38813"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=38808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=38808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=38808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}