Increase / Change MySQL Import Size in PHPMyAdmin

By default the size limit for importing MySQL database is 2 MB. To increase this limit you will have to change the php.ini file which can be located in C:\WAMP\BIN\Apache\php.ini if you are using WAMP.

Search

upload_max_filesize

upload_max_filesize represents the size of one file which you can import. Change  it’s value to the desired size, the default will be 2M where M represents MB

Search

post_max_size

 Give it a larger value than upload_max_filesize

Search

memory_limit

and give it a larger value than both upload_max_filesize & post_max_size

Restart the WAMP server or restart it’s services and you are all set-up

Join the Conversation

2 Comments

Leave a comment

Your email address will not be published.