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.
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
- Edit php.ini file
- Change ExecTimeLimit
- Restart Wamp Server
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
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.
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.
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.
Import Big Database (SQL file) to PhpMyAdmin WAMP Server
Latest posts by KarSho (see all)
- Step to uninstall Android Studio fully on Mac - June 14, 2018
- Step to install new Python Package from inside of IPython - June 14, 2018
NICE TUTORIAL. Thank you
thank you nice nice
tank you Mr KarSho,Your presentation was very useful,Thank you very much
FYI:
.
XAMPP server on Windows:
.
The “php.ini” file default location: “C:\xampp\php\php.ini”
.
The two forward-slash characters within the code of step 3 (“// “) that are intended as inline comment starting points, must be replaced with a single semi-colon character (“;”)
Thank you