Increase PHPMyAdmin Import Size Ubuntu and XAMPP

In Increase PHPMyAdmin Import Size, When we create a website or import the website from another server to our local system to test then for setup we have to import the complete database as well.

Increase phpMyAdmin Import Size UBUNTU and XAMPP
Increase PHPMyAdmin Import Size UBUNTU & XAMPP

By default the import size of phpMyAdmin is 2MB, we can Increase phpMyAdmin Import Size on UBUNTU and XAMPP both using an installed PHP configuration file named php.ini.

Here we discuss about, Increase phpMyAdmin Import Size UBUNTU and XAMPP step by step.

2+ Steps to Increase phpMyAdmin Import Size in Ubuntu

Here are complete 3 steps to Increase phpMyAdmin Import Size in Ubuntu 16.04 or newer version and in the same you can have either PHP 5 or PHP 7.


Open php.ini of the appropriate PHP version(s).

  • For PHP v5.0
    sudo -H gedit /etc/php5/apache2/php.ini
  • For PHP v7.0
    sudo -H gedit /etc/php/7.0/apache2/php.ini
  • For PHP v7.1
    sudo -H gedit /etc/php/7.1/apache2/php.ini
  • For PHP v7.2
    sudo -H gedit /etc/php/7.2/apache2/php.ini
  • For PHP v7.3
    sudo -H gedit /etc/php/7.3/apache2/php.ini


Now need to increase the below parameters in the php.ini file.

  • memory_limit = 1500M
  • post_max_size = 1500M
  • upload_max_filesize = 1500M

post_max_size should be larger than upload_max_siz


Now we need to restart your apache server to effect changes. Run below command,

How to increase max import size in PHPMyAdmi XAMPP

To Increase the file size limit in XAMPP, we have to just modify only our same PHP configuration file.

PHP INI file Path


  • max_execution_time = 5000
  • max_input_time = 5000
  • memory_limit = 1000M
  • post_max_size = 750M
  • upload_max_filesize = 750M

After doing the above changes you need to restart Apache Module from XAMPP Control Panel..

If you have any issue with modify the configuration than please take backup first.

Also, you can open the apache PHP.INI file using the control panel, click on config.

To know more about PHPMyAdmin click here:

Also Check:

Happy Coding..!

Was this article helpful?
My name is Bikash Kr. Panda. I own and operate PHPCODER.TECH. I am a web Programmer by profession and working on more than 50 projects to date. Currently I am working on the web-based project and all the CMS and frameworks which are based on PHP.
Posts created 188

4 thoughts on “Increase PHPMyAdmin Import Size Ubuntu and XAMPP

Leave a Reply

Your email address will not be published.

Related Posts

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top