Fix Maximum execution time error in phpMyadmin

If you are using Xampp version on Windows, importing a large database can sometimes give a Maximum execution time exceeded error.

To fix this carry out the below steps:

1. Add this line to xampp\phpmyadmin\config.inc.php

$cfg['ExecTimeLimit'] = 6000;

2. Changexampp\php\php.ini to

post_max_size = 2048M

upload_max_filesize = 2048M

max_execution_time = 5000

max_input_time = 5000

memory_limit = 1000M

3. Add change xampp\mysql\bin\my.ini

max_allowed_packet = 200M

For more info click here.