Today we have a local installation of a project that has a database of more than 50MG. By default, Phpmyadmin only supports 2MG forcing us to make some changes to the PHP.INI file and so to import the database

The changes are as follows:

• we need to know what version of PHP is installed, in our case PHP5
• edit the PHP.INI file (etc/php5/apache2/php.ini)
• we find max_execution_time and we modify value with 300
• we find memory_limit and we modify value with 128MG
• we find post_max_size and we modify value with 80MG
• we find upload_max_filesize and modify value with80MG

If this solution is not to import large databases can see what happens with the file config.inc.php of phpmyadmin and make the following changes:

• $cfg['ExecTimeLimit'] = 300; if there is not we can create
• $cfg['ExecTimeLimit'] = 3600; change the value

We have detected that this problem is presented when using a server with Plesk

Then we had to restart the server to assume the changes:

sudo /etc/init.d/apache2 stop

sudo /etc/init.d/apache2 start