{"id":14,"date":"2016-09-11T04:33:17","date_gmt":"2016-09-10T20:33:17","guid":{"rendered":"http:\/\/apps.badjoerichards.com\/apps\/developerhack\/?p=14"},"modified":"2016-10-07T02:17:05","modified_gmt":"2016-10-06T18:17:05","slug":"increase-phpmyadmin-upload-limit-ispconfig-3","status":"publish","type":"post","link":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/","title":{"rendered":"How to increase phpMyAdmin upload file size limit in ISPConfig 3?"},"content":{"rendered":"
\"phpMyAdmin
phpMyAdmin showing an upload limit of 2MB<\/figcaption><\/figure>\n

 <\/p>\n

This is a crappy problem, especially when importing & exporting large\u00a0databases.<\/p>\n

To increase the upload file size limit for phpMyAdmin, we’ll need to modify the php settings (php.ini) that it uses on your ISPConfig installation.<\/p>\n

    \n
  1. Open up your terminal and SSH into your server.<\/li>\n
  2. Now run nano to edit your php settings.
    \nsudo nano \/etc\/php5\/apache2\/php.ini<\/code><\/li>\n
  3. Using Ctrl+W , search for:
    \nupload_max_filesize<\/code><\/li>\n
  4. And set it to:
    \nupload_max_filesize = 64M<\/code>
    \nWhere 64M means, an upload limit of 64MB.<\/p>\n

    \"nano
    nano showing search for upload_max_filesize<\/figcaption><\/figure><\/li>\n
  5. Next, search for:
    \npost_max_size<\/code><\/li>\n
  6. And set it to:
    \npost_max_size = 64M<\/code><\/li>\n
  7. Save your changes by hitting Ctrl+O and then Y.<\/li>\n
  8. Finally, restart apache.
    \nservice apache2 restart<\/code><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      This is a crappy problem, especially when importing & exporting large\u00a0databases. To increase the upload file size limit for phpMyAdmin, we’ll need to modify the php settings (php.ini) that it uses on your ISPConfig installation. Open up your terminal and SSH into your server. Now run nano to edit your php settings. sudo nano … Continue reading “How to increase phpMyAdmin upload file size limit in ISPConfig 3?”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[2,4],"tags":[],"yoast_head":"\nHow to increase phpMyAdmin upload file size limit in ISPConfig 3? - Developer Hack<\/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:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to increase phpMyAdmin upload file size limit in ISPConfig 3? - Developer Hack\" \/>\n<meta property=\"og:description\" content=\"  This is a crappy problem, especially when importing & exporting large\u00a0databases. To increase the upload file size limit for phpMyAdmin, we’ll need to modify the php settings (php.ini) that it uses on your ISPConfig installation. Open up your terminal and SSH into your server. Now run nano to edit your php settings. sudo nano … Continue reading "How to increase phpMyAdmin upload file size limit in ISPConfig 3?"\" \/>\n<meta property=\"og:url\" content=\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/\" \/>\n<meta property=\"og:site_name\" content=\"Developer Hack\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-10T20:33:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-10-06T18:17:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-content\/uploads\/sites\/4\/2016\/09\/deleteme-2.jpg\" \/>\n<meta name=\"author\" content=\"Bad Joe\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bad Joe\" \/>\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:\/\/apps.badjoerichards.com\/apps\/developerhack\/#website\",\"url\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/\",\"name\":\"Developer Hack\",\"description\":\"Hacks, tips, tricks and best practices for developers\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/\",\"url\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/\",\"name\":\"How to increase phpMyAdmin upload file size limit in ISPConfig 3? - Developer Hack\",\"isPartOf\":{\"@id\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#website\"},\"datePublished\":\"2016-09-10T20:33:17+00:00\",\"dateModified\":\"2016-10-06T18:17:05+00:00\",\"author\":{\"@id\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#\/schema\/person\/01df012e94dd976ac49e50cdbf0e38d6\"},\"breadcrumb\":{\"@id\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to increase phpMyAdmin upload file size limit in ISPConfig 3?\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#\/schema\/person\/01df012e94dd976ac49e50cdbf0e38d6\",\"name\":\"Bad Joe\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5d413dbb6a01d82a56f2ceb6a82e8704?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5d413dbb6a01d82a56f2ceb6a82e8704?s=96&d=mm&r=g\",\"caption\":\"Bad Joe\"},\"url\":\"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to increase phpMyAdmin upload file size limit in ISPConfig 3? - Developer Hack","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/","og_locale":"en_US","og_type":"article","og_title":"How to increase phpMyAdmin upload file size limit in ISPConfig 3? - Developer Hack","og_description":"  This is a crappy problem, especially when importing & exporting large\u00a0databases. To increase the upload file size limit for phpMyAdmin, we’ll need to modify the php settings (php.ini) that it uses on your ISPConfig installation. Open up your terminal and SSH into your server. Now run nano to edit your php settings. sudo nano … Continue reading \"How to increase phpMyAdmin upload file size limit in ISPConfig 3?\"","og_url":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/","og_site_name":"Developer Hack","article_published_time":"2016-09-10T20:33:17+00:00","article_modified_time":"2016-10-06T18:17:05+00:00","og_image":[{"url":"http:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-content\/uploads\/sites\/4\/2016\/09\/deleteme-2.jpg"}],"author":"Bad Joe","twitter_card":"summary","twitter_misc":{"Written by":"Bad Joe","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#website","url":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/","name":"Developer Hack","description":"Hacks, tips, tricks and best practices for developers","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/","url":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/","name":"How to increase phpMyAdmin upload file size limit in ISPConfig 3? - Developer Hack","isPartOf":{"@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#website"},"datePublished":"2016-09-10T20:33:17+00:00","dateModified":"2016-10-06T18:17:05+00:00","author":{"@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#\/schema\/person\/01df012e94dd976ac49e50cdbf0e38d6"},"breadcrumb":{"@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/increase-phpmyadmin-upload-limit-ispconfig-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/"},{"@type":"ListItem","position":2,"name":"How to increase phpMyAdmin upload file size limit in ISPConfig 3?"}]},{"@type":"Person","@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#\/schema\/person\/01df012e94dd976ac49e50cdbf0e38d6","name":"Bad Joe","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5d413dbb6a01d82a56f2ceb6a82e8704?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5d413dbb6a01d82a56f2ceb6a82e8704?s=96&d=mm&r=g","caption":"Bad Joe"},"url":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/posts\/14"}],"collection":[{"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":8,"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/posts\/14\/revisions"}],"predecessor-version":[{"id":24,"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/posts\/14\/revisions\/24"}],"wp:attachment":[{"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/media?parent=14"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/categories?post=14"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/apps.badjoerichards.com\/apps\/developerhack\/wp-json\/wp\/v2\/tags?post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}