how to extend limit of import file in phpmyadmin

Edit /etc/php5/apache2/php.ini, set upload_max_filesize and post_max_size to 150M and restart Apache:

sudo service apache2 restart

You should then be able to upload your SQL dump using phpMyAdmin.

Once you’ve done that, it’s safer to lower the size limit back to a reasonable value like 8M or so. Don’t forget to restart Apache after editing php.ini.

To Increase Upload File Size Limit Via FTP:

1. Login with your SSH root password.

2. Choose SFTP and connect. within /etc folder search for php.ini file and change the three php.ini files in the following folders

/php/7.2/cli/ /php/7.2/cgi/ /php/7.2/apache2/ folders

(depending on php version, folders might be different)

memory_limit 128M post_max_size 128M upload_max_filesize 128M

Restart Apache Server

Hello, all

You can create a php info file in order to check the current values and check which is the php.ini file in use. Create the following file in your public_hmtl folder - phpinfo.php and put the following code inside it:

<?php
phpinfo();
?>

You can also use the following command in order to find the location of the php.ini file:

php -i | grep php.ini

The output will be:

Configuration File (php.ini) Path => /etc/php/7.2/cli
Loaded Configuration File => /etc/php/7.2/cli/php.ini

Then check for the current value of upload_max_filesize you can also check which is the configuration file - php.ini that is currently used and apply the changes there (if the site using the global php.ini file and you change the values for these settings this will make the changes globally for all sites). Ideally you would like to have the following values:

upload_max_filesize = 200M

You also need to restart your web server in order the changes to take effect.

Hope that this helps! Regards, Alex