The default file import/upload size in phpMyAdmin is 2MB, For increasing file import size You need to make some changes in php.ini file and restart apache server. After changing following parameter you’ll able to import big .sql file easily.
Here i am going to take example of XAMPP server ,
step 1. open xampp control panel
step 2. click on apache config then one drop down open where you find php(php.ini) file click on it then open it on any text editor.
step 3. find below value and increased it as per your requirement
post_max_size = 500M upload_max_filesize = 500M max_execution_time = 5000 max_input_time = 5000 memory_limit = 1000M
Note: don’t forget to allocate larger value to memory_limit then post_max_size.
step 4. save file and restart XAMPP server