Monday, February 16, 2009

MySQL 3.23.49 Installation

First you must download the zip file at

Extract the file into "C:\mysql\"

Goto command line and install the server as a service. In this example I am using "mysql" as my service.

Type the following into the command line:
C:\mysql\\bin\mysqld" --install mysql

SMTP Service Configuration on IIS

Steps:
  1. Goto Start menu, click Control Panel.
  2. Double-click Add or Remove Programs.
  3. From the left pane, click Add/Remove Windows Components.
  4. From the Components list, click Application Server, and then click Details.
  5. From the Subcomponents of Application Server list, click Internet Information Services (IIS), and then click Details.
  6. From the Subcomponents of Internet Information Services (IIS) list, select the SMTP Service check box.
  7. Click OK.
  8. Click Next. You might be prompted for the Windows Server 2003 family CD or the network install path.
  9. Click Finish.
Note: When you install the SMTP service, a default SMTP server configuration is created with a message store inLocalDrive:\Inetpub\Mailroot. When setting up the SMTP service for the first time, you can configure global settings for a SMTP virtual server, as well as settings for individual components of the virtual server.

Restore Mysql Database

Syntax:
mysql - u user_name -p your_password database_name "<" file_name.sql

IIS Configuration using Control Panel

Steps:
1. Goto Start menu, click Control Panel.
2. Double-click Add or Remove Programs.
3. Click Add/Remove Windows Components.
4. In the Components list box, click Application Server.
5. Click Details.
6. Click Internet Information Services Manager.
7. Click Details to view the list of IIS optional components. For a detailed description of IIS optional components, see "Optional Components" in this topic.
8. Select all optional components you wish to install.

IIS Configuration using Server Wizard

Steps:
  1. Goto Start menu and click Manage Your Server.
  2. Under the Managing Your Server Roles, click Add or remove a role.
  3. Read the preliminary steps in the Configure Your Server Wizard and click Next.
  4. Under Server Role, click Application server (IIS, ASP.NET) and then click Next. By default, the wizard installs and enables IIS, COM+, and DTC.
  5. If you want to serve either of the optional technologies (FrontPage Server Extensions or ASP.NET), on the Application Server Options page, select the appropriate check boxes, and then click Next.
  6. Read the summary and click Next.
  7. Complete the wizard, and then click Finish.

Sunday, February 15, 2009

PHP 4.4.8 Installation on IIS 6.0

First you must download PHP from http://smithii.com/files/php4_installer-1.5-win32.zip (or goto http://www.php.net/downloads.php), unzip it anywhere you want (Desktop - recommended) and then open the folder where you unzipped the file and run the setup.

Backup php.ini, rename it into php.ini_old (or anything you want). It is a good practice if you always backup the original php.ini file.

Rename php.ini-recommended to php.ini and move it to C:\WINDOWS.
Move php4ts.dll to C:\WINDOWS\System32

GOTO Start » Administrative Tools » click Internet Information Services (IIS) Manager


Expand your local computer and select Web Service Extensions


Click Add a New Web service extension and type “PHP” on the text box and check Set extension status


Add the path to php4isapi.dll and click OK twice all the way


Expand Web Sites and Right Click on the Default Web Site and go to Properties


Click Home Directory tab and set Execute Permissions to Scripts and Executables


Click Configuration option and then Add
 

Set Executable path the path of php4isapi.dll and type “.php” on Extension textbox.
 

Click OK all the way

Restart Default Web Site:
  • Right click Default Web Site and select Start

  • Right click Default Web Site and select Start