Increase PHPMyAdmin Import Size Ubuntu and XAMPP

By | November 17, 2020

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.

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:

Happy Coding..!

Share and Enjoy !

0Shares
0 0

Subscribe For Latest Updates

Sign up to best of PHP Code Solutions, informed analysis and opinions on what matters to you.
Invalid email address
We promise not to spam you. You can unsubscribe at any time.

Leave a Reply

Your email address will not be published. Required fields are marked *