WampServer

You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

how to resolve this??

[localhost]:

1.16 I cannot upload big dump files (memory, HTTP or timeout problems).

Starting with version 2.7.0, the import engine has been re–written and these problems should not occur. If possible, upgrade your phpMyAdmin to the latest version to take advantage of the new import features.

The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings:

* Look at the $cfg['UploadDir'] feature. This allows one to upload a file to the server via scp, ftp, or your favorite file transfer method. PhpMyAdmin is then able to import the files from the temporary directory. More information is available in the Configuration section of this document.
* Using a utility (such as BigDump) to split the files before uploading. We cannot support this or any third party applications, but are aware of users having success with it.
* If you have shell (command line) access, use MySQL to import the files directly. You can do this by issuing the "source" command from within MySQL: source filename.sql.



Edited 1 time(s). Last edit at 09/08/2009 08:12AM by WoAnerges.

[forum.wampserver.com]

I have the same problem as you and this is how far i could come so far WITH help.
But still, as you can read, my problem ain´t solved.

# create C:\wamp\apps\phpmyadmin3.5.1\.htaccess
php_value upload_max_filesize 120M
php_value post_max_size 120M
php_value max_execution_time 200
php_value max_input_time 200

Its much easier to use the 'MySQL Console' to reload large database files.


left click wampmanager icon in the system tray -> MySQL -> MySQL Console

Enter the 'root' password which is nothing ( just press enter key ) unless you changed it.

Select the database you want to reload like this

USE Database_name;

Then load the dump file like this

SOURCE C:\folder\where\you_saved\your\dumpfile.sql

If you get any problems its all documented on the MYSQL Web Site.

Easy and Step by Step Solution are here,
Here we are giving cause and answer with explanation.

[www.steptoinstall.com]