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

OR

2)

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

3 thoughts on “How to upload / import mysql phpmydadmin database larger than 2MB

  1. This is a very interesting web page and I have enjoyed reading many of the articles and posts contained on the website, keep up the good work and hope to read some more interesting content in the future. Absolutely this article is incredible. And it is so beautiful.

Leave a Reply