To solve this issue you have to do these 3 things and it worked:

1. Made sure the Collation of the exported database is the same as the newly created one.

2. 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

3. Made this change in my \phpmyadmin\libraries\config.default.php file:

change

$cfg['ExecTimeLimit'] = 300;

to

$cfg['ExecTimeLimit'] = 0;

(So there is no limit)