WAMP : Some useful pointers

First of all, the location of web root with reference to my test machine :

D:\wamp\www

My Root username was root and no password

———————————————————————————

To start the service you can start wampserver. This creates a control instance to the right bottom side. You can left click over the icon and you can find all the options to run/stop/restart services or could manually start / stop mysql / apache services from the pop up menu.

———————————————————————————

Virtual host setting up

———————————————————————————

Location : D:\wamp\bin\apache\Apache2.2.11\conf

Open httpd.conf and uncomment below line to look as below

# Virtual hosts
Include conf/extra/httpd-vhosts.conf

Vhost files are located inside

D:\wamp\bin\apache\Apache2.2.11\conf\extra

with name : httpd-vhosts.conf. Add virtual host to this.

————————————————————————–

If you want to configure a folder to be accessible from outside add something as below on the httpd.conf file:

<Directory “D:/wamp/www/saffron/sites/modules/_custom/sync/”>
Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Allow from all
Allow from 127.0.0.1
</Directory>

—————importing a sql dump from prompt——————————

If you got a dump file , which is large and phpmyadmin doesnt support you can use the mysql command prompt. The wampserver control panel gives a mysql console which I found tough to do a import.

I did , by opening up a windows command prompt, typing in the path to mysql.exe and username and password and path to the dump file as below.Note, the sql dump , was placed in the same bin folder.

C:\>D:\wamp\bin\mysql\mysql5.1.32\bin\mysql -u{dbusername} -p{dbpassword} {dbname} < D:\wamp\bin\mysql\mysql5.1.32\bin\sqldump.sql

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: