if you are using WAMP, you may notice that your phpMyadmin allows you to import only 2mb file size. well yesterday i had to  import a file which was greater than the limit. my project database size was 6mb so i had to split the whole file in three. that was time consuming and annoying ! so i edited some stuff in phpMyadmin libraries! this is very simple. you just have to find the right file and increase the size limit..

so if you want to increase the size limit of import file then follow this ………….

go here first www\phpmyadmin\libraries

now find the file name “common.lib.php” and open it ……

goto line # 183

you will see something like below ….

$scan['MB'] = 1048576;
$scan['Mb'] = 1048576;
$scan['M'] =  1048576;
$scan['m'] =  1048576;
$scan['KB'] = 1024;
$scan['Kb'] = 1024;
$scan['K'] = 1024;
$scan['k'] = 1024;
just increase the size of’ all ‘M’ . now run your phpMyadmin again and see the change .:)

Update: @All : please don’t follow this original post as this is not the actual (indeed stupid) way to solve this problem, Please follow all the comments in this post that have the solution of this problem. Thanks.