Once in a while, we face script timeout errors while importing the MySQL database in PHPMyAdmin. The error basically occurs when the database file is larger than the configuration in PHP itself. Here is the quick fix that can help you.

mysql phpmyadmin limit

Increase PHPMyAdmin MySQL Import Limit

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

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

sudo nano /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: (Ctrl + w for search in nano editor)

post_max_size = 400M

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, and you are set.

sudo systemctl restart apache2

This is the easy fix for the upload size limit in PHPMyAdmin. We here at Cloudlaya can help you migrate your websites, email hosting, web hosting, cloud consulting, and DevOps engineering. Contact us today to get a free quote.