How to increase phpMyAdmin import file size by editing php.ini file

“Increase PHPmyadmin upload limit“

Are you trying to increase phpMyAdmin import database file size? It’s something that many people struggle with when they migrate their website to AWS, DigitalOcean, Vultr. There is a simple way to fix this issue. In this article, you will learn exactly how to increase max upload size in phpMyAdmin on your server.

The solution works on Ubuntu 18.04 or newer versions. To increase the upload limit, please follow these steps:

Steps to Extend import file size in phpMyAdmin

By default in phpMyAdmin the maximum file size upload limit is 2MB. This is not enough to upload a larger size database, as it’s often the case. When I migrated my website to AWS, my database size was 16MB. In your case, it could be even larger.

To increase the maximum upload limit, we have only one solution: 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

1. Connect through SSH to your AWS/DigitalOcean server using PuTTy (or any other SSH client).

2. Run the command below through which you can edit the php.ini file.

sudo nano /etc/php/*.*/apache2/php.iniCode language: JavaScript (javascript)

In the example above, replace *.* with your PHP version. For example, if your server uses PHP 7.4, the command would be:

sudo nano /etc/php/7.4/apache2/php.ini

3. Search for upload_max_filesize and post_max_size in your php.ini file and change their values as in the snippet below:

post_max_size = 40M
upload_max_filesize = 40M

4. After setting the value, now, save the settings by pressing Ctrl+X, then, press Y , hit Enter and run the following command:

sudo service apache2 reload

Congrats! You have increased the upload limit in PHPMyAdmin (and WordPress, if you’re using it too).

Conclusion

Now that you know exactly how to increase PHPmyadmin import file size , you can use this knowledge to fix this problem. Why hire someone from Fiverr or Upwork to increase upload limit WordPress when you can do it yourself in minutes? 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 share it with your friends.