WampServer

I just upgraded wampserver on my laptop (64bit Win10 + McAfee antivirus) to the latest version (v3) and it launches to a green icon on the icon bar as expected. Before upgrading, I uninstalled the previous version and installed all the VC patches recommended in the docs.

In phpMyAdmin I then created a new database and tried to Import an sql file that I had exported from my live server, but I keep getting the following error:

---
Request Timeout

Server timeout waiting for the HTTP request from the client.
Apache/2.4.9 (Win32) PHP/5.5.12 Server at localhost Port 80
---

I have tried installing both the 32 and 64bit versions of wampserver but get the same Request Timeout with both versions.

I have searched the forum and googled for a solution but have not found anything yet!

Can anyone help?

Thanks,

Phil.



Edited 1 time(s). Last edit at 12/14/2015 12:44PM by philiplardner.

Hi,

In wamp\alias\phpmyadmin.conf you may increase values of :

# To import big file you can increase values
  php_admin_value upload_max_filesize 128M
  php_admin_value post_max_size 128M
  php_admin_value max_execution_time 360
  php_admin_value max_input_time 360

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

Hi Otomatic,

Thanks for the reply. I tried increasing those values but it did not affect the problem.

Importing a database (just 9Mb in size) times-out after exactly 60 seconds.

Any other ideas?


Phil.

Hi,

See ERRORS in log files :
- Wampmanager icon->PHP->PHP error log
- Wampmanager icon->MySQL->MySQL log

Warning : MySQL is very talkative and errors are embedded in a multitude of information.

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

You probably changed the wrong php.ini file

Use the wampserver menus to get to the php.ini file that is used by APache.

wampmanager -> PHP -> php.ini

---------------------------------------------------------------------------------------------
(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-

Otomatic Wrote:
--------------
> Hi,
>
> See ERRORS in log files :
> - Wampmanager icon->PHP->PHP error log
> - Wampmanager icon->MySQL->MySQL log

I deleted the contents of both the PHP and MySQL error logs and attempted to import a database again. Here are the freshly generated error logs:


php_error.log:
[21-Dec-2015 11:08:52 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_intl.dll' - The specified module could not be found.

in Unknown on line 0

[21-Dec-2015 11:08:52 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_ldap.dll' - The specified module could not be found.

in Unknown on line 0

[21-Dec-2015 11:08:54 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_intl.dll' - The specified module could not be found.

in Unknown on line 0

[21-Dec-2015 11:08:54 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_ldap.dll' - The specified module could not be found.

in Unknown on line 0

=======================

I checked, and both php_intl.dll and php_ldap.dll exist and are in the correct directory.

=======================

mysql.log:
2015-12-21 11:08:11 10908 [Note] wampmysqld: Arrêt normal du serveur

2015-12-21 11:08:11 10908 [Note] Giving 0 client threads a chance to die gracefully
2015-12-21 11:08:11 10908 [Note] Event Scheduler: Purging the queue. 0 events
2015-12-21 11:08:11 10908 [Note] Shutting down slave threads
2015-12-21 11:08:11 10908 [Note] Forcefully disconnecting 0 remaining clients
2015-12-21 11:08:11 10908 [Note] Binlog end
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'partition'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_METRICS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_CMP'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'INNODB_TRX'
2015-12-21 11:08:11 10908 [Note] Shutting down plugin 'InnoDB'
2015-12-21 11:08:11 10908 [Note] InnoDB: FTS optimize thread exiting.
2015-12-21 11:08:11 10908 [Note] InnoDB: Starting shutdown...
2015-12-21 11:08:13 10908 [Note] InnoDB: Shutdown completed; log sequence number 1626027
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'BLACKHOLE'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'ARCHIVE'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'MRG_MYISAM'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'MyISAM'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'MEMORY'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'CSV'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'sha256_password'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'mysql_old_password'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'mysql_native_password'
2015-12-21 11:08:13 10908 [Note] Shutting down plugin 'binlog'
2015-12-21 11:08:13 10908 [Note] wampmysqld: Arrêt du serveur terminé

2015-12-21 11:08:52 4452 [Note] Plugin 'FEDERATED' is disabled.
2015-12-21 11:08:52 4452 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-12-21 11:08:52 4452 [Note] InnoDB: The InnoDB memory heap is disabled
2015-12-21 11:08:52 4452 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-12-21 11:08:52 4452 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-21 11:08:52 4452 [Note] InnoDB: Not using CPU crc32 instructions
2015-12-21 11:08:52 4452 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-12-21 11:08:52 4452 [Note] InnoDB: Completed initialization of buffer pool
2015-12-21 11:08:52 4452 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-21 11:08:52 4452 [Note] InnoDB: 128 rollback segment(s) are active.
2015-12-21 11:08:52 4452 [Note] InnoDB: Waiting for purge to start
2015-12-21 11:08:52 4452 [Note] InnoDB: 5.6.17 started; log sequence number 1626027
2015-12-21 11:08:52 4452 [Note] Server hostname (bind-address): '*'; port: 3306
2015-12-21 11:08:52 4452 [Note] IPv6 is available.
2015-12-21 11:08:52 4452 [Note] - '::' resolves to '::';
2015-12-21 11:08:52 4452 [Note] Server socket created on IP: '::'.
2015-12-21 11:08:53 4452 [Note] Event Scheduler: Loaded 0 events
2015-12-21 11:08:53 4452 [Note] wampmysqld: ready for connections.
Version: '5.6.17' socket: '' port: 3306 MySQL Community Server (GPL)

The PHP error are not serious but can be fixed with a couple of clicks on the wampmanager menu.

wampmanager -> Apache -> Version -> 2.4.9
( click on the version number, and wait 3 seconds for apache to restart )

The MySQL error log shows no errors, but you can make the error message come out in English if you wish by changing this in the `my.ini` file, again use the menus to edit this file

wampmanager -> MySQL -> my.ini

Find this line

# Change your locale here !
lc-messages=fr_FR

And change it to

# Change your locale here !
lc-messages=en_GB

Or `en_US`



Not sure where you are now, as you stated in your original question that you installed WAMPServer 3.0.0, but your MYSQL version is saying its MYSQL5.6.17.

WAMPServer V3 comes with MYSQL5.7.9 and WAMPServer 2.5 came with MYSQL5.6.17


Maybe you had better run the wampserver homepage and take a look at what version of what you are actually running!

---------------------------------------------------------------------------------------------
(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-