How to increase phpmyadmin upload file size

To increase MySQL phpmyadmin import file size in Ubuntu 16.04 or newer, follow these steps. In the newest Ubuntu version you can have either PHP 5 or PHP 7.

Step - 1: 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
  

Step - 2: Now need to increase below parameters in the php.ini file.

memory_limit = 1500M

post_max_size = 1500M

upload_max_filesize = 1500M

Please Note : post_max_size should be larger than upload_max_size

Step - 3: Now you need to restart your apache server to effect changes.

sudo service apache2 restart

1. create info.php page and check all details about file

   <?php 
     phpinfo();
   ?>
   

2. run in your browser search upload_max_filesize and post_max_size change by default value 2M to 80M.

3. Run

   sudo -H gedit /etc/php5/apache2/php.ini
   

4. change both values upload_max_filesize and post_max_size
   change by default value 2M to 80M

5. Restart apache

   sudo /etc/init.d/apache2 restart
   

The first things to check (or ask your host provider to check) are the values of max_execution_time, upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP.

Please note that post_max_size needs to be larger than upload_max_filesize.