Increase Import Max File Size for PHPMyAdmin – Azure App Service

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.

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.

  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

  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.

  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

About the author

Joshua Holdeman is a DevOps Engineer, Software Engineer and Digital Marketing Consultant. With over 10 years in the industry and backed by hundreds of digital marketing projects and websites developed under his direction, he brings experience and knowledge which allows for the recommendation of online software for all of your business needs. 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