How to Increase phpMyAdmin Import File Size in Azure App Services

Increase Import Max File Size for phpMyAdmin

If you have a large database and are looking to migrate your website, or are hosting your web app using Microsoft Azure App Services, you may run into issues when trying to import the SQL file. In this tutorial, you will learn how to increase phpMyAdmin import file size and upload limit in Azure App Services.

By default, the maximum upload size when importing a SQL file using phpMyAdmin via SiteExtension or with MySQL in-app on Azure App Services is set to 8MB.

This is due to the default upload_max_filesize and post_max_size for PHP configured on Azure Web Apps.  To increase the value, you’ll need to modify both the local and master values for PHP.

Steps to Increase Import Max File Size for phpMyAdmin in Azure Web Apps:

  1. In the Azure Portal, select your web app and go to “Application Settings”.

  2. Go to the App Settings section and add the following key and value and press save.

    KEY = PHP_INI_SCAN_DIR
    VALUE = D:\home\site\ini
    Azure Web App Settings

  3. Go to the KUDU site for your web app.

    (https://<sitename>.scm.azurewebsites.net/debugconsole)

  4. Go to site directory and press the “+” button and create an “ini” directory.

    KUDU Debug Console

  5. In the ini directory, create an “extensions.ini” file.

  6. Press the edit button next to the file.

  7. Add the following to the file and save.  This will modify the Master values.

    upload_max_filesize=30M
    post_max_size=30M

  8. Go to the wwwroot directory and create a “.user.ini” file.

  9. Edit the file and add the same values as mentioned in step 7 above. This will modify the Local values.

  10. Restart the site using the Azure Portal.

  11. phpMyAdmin Import page will also reflect the changes.

Source: https://docs.microsoft.com/en-us/archive/blogs/azureossds/increase-import-max-file-size-for-phpmyadmin-azure-app-service


Last updated on by Joshua Holdeman

Joshua Holdeman
About the author

Joshua Holdeman is a DevOps Engineer, Sr. Software Engineer, and Digital Marketing Consultant. With over 12 years in the industry and backed by hundreds of digital marketing projects and websites developed under his direction, he brings experience and knowledge allowing for the recommendation of high-impact business software, tools, and programs to help non-profit organizations, small businesses, and entrepreneurs to launch or grow their business. Before starting this blog, Josh was the Sr. Software Engineer for a world leader in a marketing and graphic communications franchise system.

Leave a Reply

Join Our Newsletter to Receive Helpful Tips to Launch & Grow Your Business

Including FREE Access to our 7-Day Essential Business Tools Checklist