Solution:1
This issue is not because of corrupt database. I found the solution from this video – https://www.youtube.com/watch?v=MqOsp54EA3I
It is suggested to increase the values of two variables in php.ini file. Change following in php.ini
upload_max_filesize=64M
post_max_size=64M
Then restart the server.
This solved my issue. Hope solves yours too.
Solution:2
Compress your .sql file, and make sure to name it .[format].[compression], i.e. database.sql.zip.
As noted above, PhpMyAdmin throws this error if your .sql file is larger than the Maximum allowed upload size — but, in my case the maximum was 50MiB despite that I had set all options noted in previous answers (look for the “Max: 50MiB” next to the upload button in PhpMyAdmin).
Solution:3
For me, adjusting the 2 values was not enough. If the file is too big, you also need to adjust the execution time variables.
First, ../php/php.ini
upload_max_filesize=128M
post_max_size=128M
max_execution_time=1000
Then, ../phpMyAdmin\libraries\config.default.php
$cfg[‘ExecTimeLimit’] = 1000;
This did the trick for me. The variables can be choosen differently of course. Maybe the execution time has to be even higher. And the size depends on your filesize.