{"id":746,"date":"2024-10-07T09:43:58","date_gmt":"2024-10-06T23:43:58","guid":{"rendered":"https:\/\/www.cloudproinc.com.au\/?p=746"},"modified":"2024-10-07T09:44:00","modified_gmt":"2024-10-06T23:44:00","slug":"increase-phpmyadmin-upload-size-limit-on-azure-web-app","status":"publish","type":"post","link":"https:\/\/cloudproinc.azurewebsites.net\/index.php\/2024\/10\/07\/increase-phpmyadmin-upload-size-limit-on-azure-web-app\/","title":{"rendered":"Increase PHPMyAdmin Upload Size Limit on Azure Web App"},"content":{"rendered":"\n

In this Azure App Services article, we will show how to increase PHPmyAdmin Upload size limit on Azure Web App.<\/p>\n\n\n\n\n\n\n\n

PHPMyAdmin is a PHP-based open-source and free tool that allows us to manage MySQL and MariaDB databases using a web interface. The tool offers a simplified interface that makes the administration of MySQL intuitive and simple.<\/p>\n\n\n\n

MySQL deployments are very popular with WordPress, and the majority of WordPress these days runs on databases powered by MqSQL. <\/p>\n\n\n\n

When deploying WordPress on Microsft Azure Web App, the deployment comes with the Azure MySQL database fully hosted and managed by Azure. <\/p>\n\n\n\n

Azure Web App Upload Limit <\/h2>\n\n\n\n

By default, Azure MySQL databases come with a 50MB upload limit. For most WordPress installations, this is not an issue; however, for large installations where you need to import and upload an existing MySQL database, this limit is not enough. This post will show you how to increase the default upload limit.<\/p>\n\n\n\n

PHPMyAdmin <\/h2>\n\n\n\n

To access your PHPMyAdmin tool, open a web browser and use the following URL (Change the webappname to your Azure Web App). <\/p>\n\n\n\n

https://WEBAPPNAME.azurewebsites.net\/phpmyadmin\/<\/code><\/pre>\n\n\n\n
The PHPMyAdmin interface is shown below.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
How to Increase PHPMyAdmin Upload Size Limit on Azure Web App<\/h2>\n\n\n\n
We must first add an environment variable to the Azure Web App to increase the default limit. Open your Azure Web App and add the following environment variable. <\/p>\n\n\n\n
Name - PHP_INI_SCAN_DIR<\/code><\/pre>\n\n\n\n
Value - \/usr\/local\/etc\/php\/conf.d\/home\/site\/wwwroot\/ini<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
After creating the environment variable, we need to create a folder called ini in the following path.<\/p>\n\n\n\n
\/home\/site\/wwwroot\/<\/code><\/pre>\n\n\n\n
To create the file, log in to the Web App using SSH. If you are unfamiliar with how to log in to your Web App using SSH.<\/p>\n\n\n\n
Once logged in to the Web App using SSH create an ini folder in the wwwroot folder.<\/p>\n\n\n\n
\/home\/site\/wwwroot\/<\/code><\/pre>\n\n\n\n
Run the following commands to set the new limit. <\/p>\n\n\n\n
echo \"upload_max_filesize=120M\" >> extensions.ini\necho \"post_max_size=120M\" >> extensions.ini<\/code><\/pre>\n\n\n\n
The above command will create a file called extentions.ini and add two configuration items. The new upload limit will be 120MB. <\/p>\n\n\n\n
the extentions.ini file should look like:<\/p>\n\n\n\n
post_max_size=120M\nupload_max_filesize=120M<\/code><\/pre>\n\n\n\n
Test New Upload Limit <\/h2>\n\n\n\n
To test the new upload limit, restart the Azure Web App. You will see the new limit next to the Browse your computer text.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n