John Sheehan's questions

I've got a Win2k8 standard server running Hyper-V with a Server 2003 web guest instance running. The host is publicly available on the internet.

I've created an Internal Private network in the Hyper-V Virtual Network manager. I've set the host IP for that virtual adapter to 192.168.0.1. I've set the IP on the guest to 192.168.0.2. They can ping each other and share files. I can't browse the web on the guest though. NSLOOKUPs are working. I've tried setting the DNS server setting on the guest to 192.168.0.1 and something external like Google's 8.8.8.8 server to no avail.

Windows firewall is disabled on the internal virtual network.

I've tried it with both DNS installed on the host and without it.

I'm not sure which RRAS/NAT settings are relevant to pass on so ask if you need me to clarify anything.

How do I get outbound internet working on the guest VM?

I was doing some server updates and stupidly decided I should get the latest version of MySql. I had version 5.0 installed. Server is Windows Server 2003. I realize this is probably not the recommended upgrade route.

Here's what I've done so far:

• Stopped the 5.0 service
• Installed 5.1
• Deleted 5.0 service
• Configured 5.1 with same config as 5.0 with config wizard
• Started 5.1 service
• Copied data from MySQL\MySQL Server 5.0\data to AppData\MySQL\MySQL Server 5.1\data
• Ran mysql_upgrade
• Recreated users/privileges.

Two of my databases work and two don't. The two that do have files in their data folders with extensions .frm, .myd, .myi. The two that don't only have .frm files.

What do I need to do to get the non-working databases going?

Edit: I suppose I should clarify 'not working'. The non-working ones show up in the MySql Administrator and phpMyAdmin, but they have no tables listed.

I have a Windows 2003/IIS6 server with a lot of application pools. In task manager, one of the w3wp.exe processes is using up a lot more resources then the others. Short of stopping/starting each pool one-by-one, is there an easy way to find out which application pool is related to the process?