28
Nov
A Few Interesting Sites…
Just a few links that are my top visited on Google Reader. Various interesting sites on a mixture of subjects. Google Reader is a great tool to catch up on the news and what’s going on in the morning with a cup of coffee. Two sugars please…
26
Nov
Import SQL File into MySQL
When moving my wordpress over to Windows I spent a little time finding out how to import a SQL dump file in to MYSQL. I didn’t find thing concrete that worked. So I used that feature, Help! and worked it out. Here are the steps I used.
1. Open MySQL Command Line Client and enter your MySQL root password
2. Select a database to import your SQL file too. Replacing “databasename” with your database name.
USE "databasename"
replacing “databasename” with your database name. Replace “C:\sqlfilenamee.sql” with the location of your SQL file.
3. Excute your SQL file by entering the following command
\. "C:\sqlfilenamee.sql"
Hit enter and your SQL file will be imported in to your database. Simples!
24
Nov
New Server
Over the past couple of days you may have notice the blog and various other sites I manage have been down over the weekend. This was mainly due to some downtime on the DNS servers, the primary, located in Newark was turned off as some building work was going on close to the server and I didn’t want tiny rocks getting in though the fans but also because I was moving the DNS server to a new host.
I thought I might as well get some experience on various systems in some of my spare time while on my placement year so I got myself a server. It’s a HP ML115 and it is now hosted in a datacentre just outside of Birmingham. I’ve beefed up the standard spec of it with some large hard drives and quite a lot of ram! It’s currently hosting 3 servers. One of which is a Windows server which is now hosting this blog. I’ve come across a few errors since as wordpress doesn’t really support IIS but I think I’ve finally cracked it. I’ve also noticed a huge decrease in page load time; it was starting to get annoying on the old host.
My next challenge is to install Exchange server. I’m struck between trying out Exchange 2010 or properly configuring Exchange 2007 but before this I need to finish configuring Active Directory.
23
Nov
Call of Duty: Modern Warfare 2
I’ve spent the last week or two on and off pretty much playing the new edition to the Call of Duty Series. Modern Warfare 2. It is an awesome game and much improved over the last COD installation from Infinity Ward. Going by the news it seems I’m not the only one that likes the game. I’ve heard that some online stores were taking 150 pre orders at its peak. However some don’t like the game due to some of its levels, Russian has banned the game due to a certain level containing and airport, terrorists and some dead civilians. While playing the level I did think that this was a little over the top more so because I read about how the levels may offend certain people. Its a game though although it could be real its not.
Single player I thought was very short. I took me 6 hours to complete, not all at once though. I’ve only playing COD4 and 5 and they seemed much longer. The story however following on from COD4 is very good and leaves it open to what I suspect will be COD8. Multi-player however is a little different to what I expected this was mainly because I got the game on XBOX rather than getting on Steam for playing on my computer. I find it quite annoying that you don’t get the options that you did on COD4 and 5. I like to be able to go on and play a certain map but on XBOX you can’t search game with a certain map unless of cause you are in a private/hosted match but my Internet connection isn’t fast enough to host.
They have took this system to the PC as well. No longer can you run and host your own dedicated server with custom settings or dedicated level rotation. This is the main reason I did not get it on the PC.
The online Multi-player on the whole is awesome too. Infinity Ward has done it again and created an awesome game.
3
Nov
Fitted The Xtreamer Cooler
I fitted the Xtreamer cooler the other night. I was a little concerned how easy the how-to made the whole process look, nothing is easy. To be fair though once I’d got the side panel off, which must have been stuck down with the worlds strongest double-sided tape the whole thing was a breeze to complete. It even looks good as an end product with the cooler attached. On a plus note it worked afterwards. I hadn’t slipped and ploughed a screwdriver across the chipset.
I haven’t however watched it enough since to see if the cooler actually works but reading around others seem to think so. Its also stopped acting up. After a little playing around after my previous post, here. It turned out the Windows Home Server wasn’t 100% happy with the Xtreamer on the network. Its fine now, the problem was the WHS, at idle spun down the hard drives when they were not in use and when the Xtreamer started to stream a file there was a delay while the hard-drives spin back up. This is ok when your streaming to Boxee, a PC etc as there is about a 2 second delay the Xtreamer however seems to get confused. I think I’ll file a bug report when I can test this more.
On a similar note the Xtreamer with its HDMI output is pushing me towards getting a HD TV. I’ve been watching the new series Life on BBC/iPlayer and the awesome shots they have in HD are just amazing but I’m stuck watching it on my PC monitor… for now.. any recommendations?