Import file size limit in PHPMyAdmin Import file size limit in PHPMyAdmin php php

Import file size limit in PHPMyAdmin


Find the file called: php.ini on your server and follow below steps

With apache2 and php5 installed you need to make three changes in the php.ini file. First open the file for editing, e.g.:

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

OR

sudo gedit /etc/php/7.0/apache2/php.ini

Next, search for the post_max_size entry, and enter a larger number than the size of your database (15M in this case), for example:

post_max_size = 25M

Next edit the entry for memory_limit and give it a larger value than the one given to post_max_size.

Then ensure the value of upload_max_filesize is smaller than post_max_size.

The order from biggest to smallest should be:

    memory_limit    post_max_size    upload_max_filesize

After saving the file, restart apache (e.g. sudo /etc/init.d/apache2 restart) and you are set.

Don't forget to Restart Apache Services for changes to be applied.


You probably didn't restart your server ;)

Or you modified the wrong php.ini.

Or you actually managed to do both ^^


Just change your php.ini(xampp/php/php.ini) file, it worked for me!

max_execution_time = 5000max_input_time = 5000memory_limit = 1000Mpost_max_size = 750Mupload_max_filesize = 750M

And, don't forget to restart Apache Module from XAMPP Control Panel.