Increase PHPmyadmin import file size by editing php.ini file
“Increase PHPmyadmin upload limit“: Friends, Do you have problems with increase phpmyadmin import database file size? It’s something that many people struggle with when they migrate their website to AWS and Digitalocean, but there is a simple way to fix the issue. In this article, you will learn exactly how to increase max upload size in PHPmyadmin and regain your life.
The solution works on Ubuntu 18.04, learn increase the upload limit is simple enough if you are willing to do the work. All it requires is the follow the steps.
Steps to Extend import file size in PHPMyAdmin
By default in PHPMyAdmin the maximum file size upload limit is 2MB, which is not enough to upload the larger size database, because, your database can be more than 2MB. In my case, when I migrated my website to AWS, my database was 16MB, for your case, it could be larger.
To increase the maximum upload limit, we have only one solution is to edit the php.ini file. Moreover, You will be happy to hear that in this way your WordPress media upload limit will also increase. So, let’s get started.
To increase the maximum upload limit by editing the php.ini file
- Login to AWS/Digitalocean server using putty software.
- Run the following command, by using this command you can edit the php.ini file.
sudo nano /etc/php/7.2/apache2/php.ini
- Search for “upload_max_filesize” and “post_max_size” in your php.ini and set the below following given value.
post_max_size = 40M
upload_max_filesize = 40M
- After setting the value, now, save the settings by pressing Ctrl+X, then, press ‘Y’ and hit enter and run the command.
sudo service apache2 reload
In this way, you can increase the maximum Upload limit in PHPMyAdmin and WordPress.
Now that you know exactly how to increase PHPmyadmin import file size , you can use this knowledge to fix this problem. Why you hire form Fiverr and Upwork to increase upload limit WordPress when you can do it yourself at home? It’s easy, so go ahead and try it. If you know any other ways to solve this problem, kindly share it in the comment section. If you find this article helpful to others, please it to your loved ones.