How to upload / import mysql phpmydadmin database larger than 2MB

There is a couple of ways to solve this problem.

1) Split your SQL file into multiple 2MB chunks



Update your 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