Import Big Database (SQL file) to PhpMyAdmin WAMP Server

by KarSho · April 12, 2015

Just share...

Sometime when you are trying to upload / import your Database ( MySql file ) in PhpMyAdmin, you may face following issue,
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
Import Big Database (SQL file) to PhpMyAdmin WAMP Server

This is common problem when your are importing or uploading large / big SQL file (database) to your WAMP server using PhpMyAdmin. Actually, Default upload file size is 2MB

So, When your file is more than 2MB, you’ll get this Error. You can easily solve this issue by increasing the Upload file size.

Solution

Find php.ini file

First find your main php.ini file.
1. Left click WAMP logo on task-bar, then click PHP -> php.ini
or
2. Goto C:\wamp\bin\apache\apache2.2.22\bin\php.ini

Edit php.ini file

In php.ini file, edit following thing for upto 2GB file size import or upload.
max_execution_time = 1800 // equals to 30 minutes
max_input_time = 1800 // equals to 30 minutes
memory_limit = 2001M // equals to 2 GB
upload_max_filesize = 2000M // equals to 2 GB
post_max_size = 2001M // equals to 2 GB
After edit save that file.
See the Notes once.

Change ExecTimeLimit

Go to following folder,
C:\wamp\apps\phpmyadmin3.5.1\libraries
and open config.default.php. There find,
$cfg['ExecTimeLimit'] = 300; //replace above code with following code $cfg['ExecTimeLimit'] = 0; // here 0 for unlimited
After edit save that file.

Restart Wamp Server

After finish above 3 steps, restart your WAMP server. Now you can easily import / upload upto 2GB size Database.

Notes:

1) upload_max_filesize should be lesser than memory_limit and post_max_size. Sometime it’s too give issue

2) Step 3 is not that much important. But you should changes for sense.