15/06/2010

"Ravens Night II" - Planning - Part 2

I came across the following blog and it's really got me exctied about the up coming season, take a look and see what you think;-

http://baltimoresportsandlife.blogspot.com/2010/06/local-media-previews-ravens-training.html

On a side note, the North Cardiff Ravens Nest has now been stocked 60 bottles of Miller MGD, so whatever happens this pre-season / season, the next Ravens night is sure to be a good one.

14/06/2010

MySQL Disaster Recovery

I’ve been asked to recover one of my old projects off my HP DL130 that sadly died around a year ago. The disks in the server are fine so I was able to mount them in a caddy and access the data.

I didn’t have any backups as this isn’t a production server, plus it was mainly university work from my degree that was running on the server. Long story short I needed to find a way to recover MySQL without using a backup.

It turns out MySQL has a “data” directory which contains a folder for each database it hosts. I first attempted to simply move the named database folder from within the data folder to my new server. This partially worked, when I opened MySQL Workbench it saw the database and allowed me to access the majority of the tables, however when I tried accessing some of the newer tables I’d created on the old server it threw an error and said they didn’t exist.

I then downloaded and installed XAMMP on a spare system and moved the whole of the data folder from the old server to my new XAMMP installation. I needed to open my.ini from the bin directory of MySQL and change the size of the log file from 5MB to 170MB to match the actual size of my log file; I also needed to comment out the time zone that XAMMP had setup.

Last thing I needed to do was change the logon username and password for MySQL under phpMyAdmin\config.inc.php this then allowed me to use phpMyAdmin to administer the databases, from here I could export the data in any number of formats and restore it to my new server.

10/06/2010

Road users move over!

Other road users have really been pissing me off recently. People who don’t use their indicators really bug me but my biggest bug bear is these people who buy small cars like the Fiat 500 then drive them like they are as wide a Hummer. I’m all for slowing down to go through Lisvane lanes, but every time these people pass a car coming in the opposite direction they flash their break lights and come to a stop, it’s really annoying and totally unnecessary.

04/06/2010

Busy May


I’ve had a really busy May. Got some Wedding stuffed sorted and got the Romania project out of the way. Romania was nice (in a way), Victoria is small town with the picturesque backdrop of the Carpathian Mountain range. People were friendly, the hotel was basic, and the food and beer was good. It’s somewhere I could live and enjoy a comfortable life, but 10 days there on Business away from creature comforts is a long time, hopefully if I have to go back next time it will only be for a brief period.