WampServer

In wamp while importing 2 gb database into phpmyadmin it gives me following error :


Fatal error: Out of memory (allocated 4980736) (tried to allocate 1969567735 bytes) in C:\wamp\apps\phpmyadmin4.1.14\libraries\zip_extension.lib.php on line 77

Please help me someone how to resolve this error...???

i add following line of code in wamp\alias\phpmyadmin.conf to increase import size of phpmyadmin

php_admin_value upload_max_filesize 900M
php_admin_value post_max_size 900M
php_admin_value max_execution_time 960
php_admin_value max_input_time 960

</Directory>

Hello radhikapratapwar,

This is not really a WAMPServer problem, but with a database that large it would be better to use the mysql command line tools. These are not limited like PHP code is.

So try :

wampmanager -> MySQL -> MySQL console

And at the comand prompt enter

use YOUR_DATABASE_NAME;

source 'C:/path/to/backup.sql';

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hay i am using 5.6.17 version of mysql on windows 8 can u plz tell me step wise procedure to import database using command prompt. i dont set password for my database.

Unless you changed it, when the command prompt window asks for a password, just hit enter. There is not password by default!

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-