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.

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.

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 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

Step-3

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

your_drive/xampp/php/php.ini

• 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: https://www.phpmyadmin.net/docs/

Also Check:

• Display Current Date and Time in HTML using JavaScript
• Load Dynamic Content in Bootstrap Modal using Ajax
• Create Dynamically Generated Text File and Download Using JavaScript

Happy Coding..!