{"id":3175,"date":"2021-10-19T12:07:20","date_gmt":"2021-10-19T12:07:20","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=3175"},"modified":"2021-10-19T12:07:33","modified_gmt":"2021-10-19T12:07:33","slug":"3175","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/3175\/","title":{"rendered":"How to Increase the Upload Limit in phpMyAdmin"},"content":{"rendered":"

If you’re trying to extend the speed of your upload in phpMyAdmin, then you’re at the correct post.<\/p>\n

The upload size limit has been exceeding, if an SQL file that’s uploaded through phpMyAdmin and therefore the post size limit, then the subsequent error can occur:<\/p>\n

phpMyAdmin \u2013 Error
\nIncorrect format parameter<\/strong><\/p>\n

This type of error is provided as a result of the a part of the file that has been uploaded because of the upload limit and where the ends up in a corrupted import.<\/p>\n

To increase the maximum upload limit in phpMyAdmin It Is necessary to extend the cPanel PHP max upload size and cPanel PHP max POST size values.<\/p>\n

2047MB may be a limit where you’ll increase the value, if the import file is larger than 2047MB, then you’ll use this command.<\/p>\n

Steps to Follow<\/strong>:<\/h3>\n

1. Log in to\u00a0WHM\u00a0<\/strong>as a root user.<\/p>\n

2. Steer to:\u00a0WHM Home => Server Configuration => Tweak Settings.<\/strong><\/p>\n

3. Now click on the\u00a0PHP<\/strong>\u00a0tab<\/p>\n

\"inc-uloadsize-1\"<\/p>\n

4. As you can see the \u201ccPanel PHP max upload size<\/strong>\u201d option over there, now increase the upload limit to your set value.<\/p>\n

\"inc-uloadsize-2\"<\/p>\n

\n

5. More than\u00a02047MB<\/strong>\u00a0values will not be permitted.<\/p>\n

6. For the \u201ccPanel PHP max POST size<\/strong>\u201d option, as you can increase the\u00a0POST<\/strong>\u00a0value according to your convince.<\/p>\n

\"inc-uloadsize-3\"<\/p>\n

7. You can\u00a0Save<\/strong>\u00a0options at the bottom of your screen and now you can save.<\/p>\n

\"inc-uloadsize-4\"<\/p>\n

Once it\u2019s completed, you will be able to see that PhpMyAdmin shows the new maximum upload size on the import screen which is next to the upload button.<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

If you’re trying to extend the speed of your upload in phpMyAdmin, then you’re at the correct post. The upload size limit has been exceeding, if an SQL file that’s uploaded through phpMyAdmin and therefore the post size limit, then the subsequent error can occur: phpMyAdmin \u2013 Error Incorrect format parameter This type of error […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,13],"tags":[],"class_list":["post-3175","post","type-post","status-publish","format-standard","hentry","category-web-hosting","category-whm"],"yoast_head":"\nHow to Increase the Upload Limit in phpMyAdmin - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/3175\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Increase the Upload Limit in phpMyAdmin - OWS KB\" \/>\n<meta property=\"og:description\" content=\"If you’re trying to extend the speed of your upload in phpMyAdmin, then you’re at the correct post. The upload size limit has been exceeding, if an SQL file that’s uploaded through phpMyAdmin and therefore the post size limit, then the subsequent error can occur: phpMyAdmin \u2013 Error Incorrect format parameter This type of error […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/3175\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-19T12:07:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-19T12:07:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/inc-uloadsize-1-300x74.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3175\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/inc-uloadsize-1.png\",\"width\":1024,\"height\":252,\"caption\":\"inc-uloadsize-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3175\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/3175\/\",\"name\":\"How to Increase the Upload Limit in phpMyAdmin - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/3175\/#primaryimage\"},\"datePublished\":\"2021-10-19T12:07:20+00:00\",\"dateModified\":\"2021-10-19T12:07:33+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/3175\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/3175\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3175\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3175\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/3175\/\",\"name\":\"How to Increase the Upload Limit in phpMyAdmin\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=3175"}],"version-history":[{"count":2,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3175\/revisions"}],"predecessor-version":[{"id":3181,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3175\/revisions\/3181"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=3175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=3175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=3175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}