I had the same problem recently.
I did these 3 things and it worked:
-
Made sure the Collation of the exported database is the same as the newly created one.
-
Made these changes in my php.ini(xampp/php/php.ini) file
max_execution_time = 5000 max_input_time = 5000 memory_limit = 1000M post_max_size = 750M upload_max_filesize = 750M
-
Made this change in my \phpmyadmin\libraries\config.default.php file:
change
$cfg['ExecTimeLimit'] = 300;
to
$cfg['ExecTimeLimit'] = 0;
(So there is no limit)