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