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.

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

Was this article helpful?
YesNo
My name is Bikash Kr. Panda. I own and operate PHPCODER.TECH, my native place in Odisha. I am a Web Programmer by profession and working on more than 50 projects to date. My passion is working on the web-based project using PHP and relate to all CMS and frameworks which is based on PHP.
Posts created 178

3 thoughts on “Increase PHPMyAdmin Import Size Ubuntu and XAMPP

Leave a Reply

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

Related Posts

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

Back To Top
mariobet - supertotobet - escort - milanobet giriş - gizabet giriş -
perabet giriş
- betkanyon giriş -

jojobet giriş

We are now accepting guest posting and creation of back-links.
This is default text for notification bar