Wednesday, January 24, 2018

WAMP 3.0 Initial settings for Windows 10



1- on WAMP: C:\wamp\bin\mysql\mysql5.6.12\my.ini, set

max_allowed_packet = 512M

under [wampmysqld64]

 2- go to C:\wamp\bin\php\php5.6.31\phpForApache.ini set session.gc_maxlifetime to 32000

 session.gc_maxlifetime = 32000 

3- Set PHP memory_limit to 1G in WAMP options

4- Right-click Wamp>wamp settings>Add localhost to url (UNchecked)

5- Uncomment the MPM config included in httpd.conf
# Server-pool management (MPM specific)
Include conf/extra/httpd-mpm.conf

6- go to conf/extra/httpd-mpm.conf
Modify mpm_winnt_module settings so it looks like this:

<IfModule mpm_winnt_module>
ThreadsPerChild        1000
ThreadStackSize 8388608
MaxConnectionsPerChild   0
</IfModule>

7- Under wamp64/alias/phpmyadmin.conf, make sure u have these values:

  php_admin_value upload_max_filesize 1024M
  php_admin_value post_max_size 1024M
  php_admin_value max_execution_time 1800
  php_admin_value max_input_time 1800

Add a site to your localhost:

Once you import the db in your localhost:

1- Wampserver > Your Virtual Hosts > Virtual Host management
2- Fill the info:
Name of the virtual host> accuglass
Complete absolute path: c:/wamp64/www/accuglass
Leave the other one blank
Click "Start the creation.."
3-Run CMD type ipconfig /flushdns hit enter
4- Right-click Wamp>tools>Restart DNS

To import large sql files:

Click your Wamp server icon -> MySql -> MySql console
Once mysql console is open. Enter your mysql password. and give these commands.

use user_database_name
 
press enter

source c:/your/sql/path/filename.sql
 
press enter

Video:

No comments:

Post a Comment