Expressly Virtual MySQL
The Blog Starter Kit uses a SQL Server 2005 Express database file for saving posts, categories, feedback, and other data. MySQL is a popular database to use with Linux; and using its latest version is recommended. Instead of installing MySQL 5 on your local computer, implement the VMware Server and run the MySQL virtual machine included with the source code download
The Blog Starter Kit database is pre-installed on the server image, which emulates the separate database/web server infrastructure that is common in many hosted environments. To get started, download VMware Server and run the installer. Be sure to request a free license for the server.
If you're using Windows XP, when you run the installer a warning message will appear that informs you of potential problems running VMware Server on a nonserver operating system. You can ignore this message and continue with the install. Another warning will appear about running the management interface manually from IIS, but you can ignore it as well because running this interface doesn't adversely affect using the VMware Server.
Download the MySQL virtual machine to a folder that is accessible to your VMware installation. Run VMware Server, and select local as the host environment. In VMware Server Console Home, select Open Existing Virtual Machine, and then click Browse (see Figure 1). Navigate to the folder containing the virtual machine download, unzip the MySQL Virtual Appliance, and select the VirtualAppliancesMySQL.vmx file. The server will load the virtual machine into the management console and display a details page.
If you're using a server like Windows 2003 as your development machine, VMware should be configured automatically to map virtual machines to your network. If you're using Windows XP Pro, follow these instructions:
- On the Details page, select Edit virtual machine settings.
- Select Ethernet from the Device list (Hardware tab).
- Select the NAT radio button (see Figure 2).
- Click OK, and then start the virtual machine using the green Start button.
Next, fire up the MySQL appliance by clicking the Start button. VMware boots up Linux as a hardware-abstracted, virtual server utilizing the same network resources as your host (local) machine. (See Figure 3.)
Figure 1. Load the VMware Server: Use this dialog to open an existing virtual machine.
Figure 2. NAT Connection Setup: Set up the virtual machine for sharing the host's IP address.
Figure 3. Virtual Database: The MySQL virtual appliance runs on the VMware Server.
In case the server doesn't obtain an IP address like the one shown in Figure 3
, follow the previous Windows XP instructions. The second-to-last line of the boot screen refers to the administration web site for the MySQL appliance. You'll need to log in to this site shortly; use "admin" for both the username and the password.