There is a couple of ways to solve this problem.
1) Split your SQL file into multiple 2MB chunks
php.ini file like following (works on dedicated/local servers – any server where you have
root user permission or allowed to overwritten the file)
Search for following settings:
post_max_size = 8M upload_max_filesize = 2M max_execution_time = 30 max_input_time = 60 memory_limit = 8M
Change to: ( or any size you want but it will depend on your server available resources )
post_max_size = 35M upload_max_filesize = 35M max_execution_time = 5000 max_input_time = 5000 memory_limit = 1000M