How to increase file import size in phpMyAdmin (WAMP Server Localhost)

increase file import size in phpMyAdmin - import large database files (WAMP)Are you trying to clone your live wordpress site to localhost (local computer)? For the very first time when you clone your site manually you will face some issues. Usually you will end up in a situation where you cannot import your database (SQL file). Due to the file upload limit you cannot import large database files and if you do so then you will see an error message like this.

“You probably tried to upload too large file” or “The file size exceeded the maximum size permitted by your PHP configuration”.

Here is a simple solution to import large database files from phpMyAdmin.

Note: This is a solution for WAMP server.

The default file import size in phpMyAdmin is 2mb (2,048KiB). Let us assume that your database file size is 4mb. You can simply compress the file (zip) and import it which will hugely reduce the size of your original database file. But what if your database file size is huge as 300mb, 400mb, 500mb like that. All you have to do is increase the file import size limit.

How to increase file import size in phpMyAdmin (WAMP server)

Step 1: Go to the folder destination where you have installed WAMP. (Usually it is C:\)

Step 2: Now locate and open php.ini files from both these locations. (C:\wamp\bin\apache\Apache2.4.4\bin and C:\wamp\bin\php\php5.4.16)

Step 3: Now in both the documents press CTRL+F and find out the following settings.

  • post_max_size
  • upload_max_filesize
  • memory_limit

For example you will see upload_max_filesize = 2m where m is MB. Change 2m to 500m or more as you like.

Change post_max_size = 8m to post_max_size = 700m or more. Change memory_limit = 8m to memory_limit = 1000m.

Other than that to avoid fatal errors like maximum time of something exceeded in line something, find and change the following values.

max_execution_time = 30 to to max_execution_time = 3000 and max_input_time = 60 to 3000.

Increase file import size in phpMyAdmin - import large database files from phpMyAdmin WAMP

When done save the php.ini files and then restart your WAMP server. Hope you have increased the file import size in phpMyAdmin.