WampServer

Version of Operating system? Windows 8
Version of Wamp Server installed? Wamp 2.5
Version of Apache you are running? Do not know how to check this
Version of MySQL you are running? Do not know how to check this
Version of PHP you are running? Do not know how to check this

What colour is your WampManager icon? ( the in the system tray ) God this sucks...I seriously am red/green color blind...I believe it is red, but I am not positive.
It could be Green, Orange or Red

Do you have a HOSTS file? [c:\windows\system32\drivers\etc\hosts] Do not know how to check this
Paste any entries relating to the domain localhost and also any relating to your Virtual Hosts if you have any.



Edited 1 time(s). Last edit at 05/21/2014 03:31PM by Seanguy71.

Hello,

I just downloaded wamp the other day, and have been following a word for word instruction for how to set it up. All seemed to be going well until I tried to Import the sql .

First of all, yes I went into the php.ini file and made the changes to up the size of the download that is possible. I did this.

; Maximum amount of memory a script may consume (500M
; [php.net]
memory_limit = 500M

(I also left the "Maximum amount of memory a script may consume (128M at 128MB and then just changed the memory limit = 500. This didn't change anything.

this

post_max_size = 500M

and this
; Maximum allowed size for uploaded files.
; [php.net]
upload_max_filesize = 500M

Still I am getting told file is too big. I need a test server so bad, as my sites mobile speed and usability is not beginning to have an affect on its rankings for search engines! I must be able to test my site to switch over to a responsive design!

Would very much appreciate any help I ca get! Thank you!

Hi,

- Do you have access to localhost (WampServer home page)?
- Do you have access to phpMyAdmin?

If you answer "YES" to both questions is that the icon is Green.
If you answer "NO to any question, it is not worth trying to import SQL files, it will not work.

It is imperative that the icon is green, so that localhost and PhpMyAdmin is accessible BEFORE you want to perform import or run php files.

What is the size of the SQL file you want to import?

> I went into the php.ini file and made the changes to up the size...
- What php.ini file did you modify?
- What is the text editor that you used?

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Ok, just found out the icon is green. I do have access to both. The file is 421MB.

Hi,

In the file wamp\alias\phpmyadmin.conf just before </Directory> insert four lines below to obtain:

  php_admin_value upload_max_filesize 512M
  php_admin_value post_max_size 512M
  php_admin_value max_execution_time 720
  php_admin_value max_input_time 720
</Directory>

With this, I managed to import large SQL files. The largest file I actually imported was 278 MB

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Ugg..Yea, this did not work. Same exact issue still. It just wont seem to change from 128MB max... There must be a way!

Hi,

With this, I actually imported a SQL file of 278 MB. I can not do testing with larger files, I do not have.

You have the solution to split your SQL file into multiple files, for example, one file per table.

You can also use command line mysqlimport.exe.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Yea I was looking at the dumper thing. Will take some time for me to understand how to use it. I am not highly technical, nor do I know much coding. If that is what will work though, then that might be what needs to be done.

What does this mean?

You can also use command line mysqlimport.exe.


Thank you very much for your help!

Hi,

> What does this mean?
> You can also use command line mysqlimport.exe.

In command line:
- mysqldump.exe for export database into SQL file
- mysqlimport.exe for import SQL file into database

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons