Import file size limit in PHPMyAdmin

Question

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size.

Why am I still seeing 2MB?

Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Answer 1

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.

Answer 2

You probably didn't restart your server ;)

Or you modified the wrong php.ini.

Or you actually managed to do both ^^