Archive for February 4th, 2008

Humor on a microsoft website?

I’m being unfair here but I saw this today on  “Microsoft’s Channel 9 website” and I thought it was pretty funny.

But then, I’m easily amused :]

02-04-200808-47-46-pmcapture.Png

PS: I actually first saw it years ago, but now I have a blog :)

Add comment February 4th, 2008

Who needs a blogger/webadmin/gardener/apartment manager?

this guy apparently.

PS: I saw this a few weeks back on Craigslist, did a screen capture and forgot to post it.

Craigslist job ad …. need a blogger/webadmin, gardner and apartment manager

Add comment February 4th, 2008

How to run both mysql5 and mysql4 on the same windows Machine.

I finally made the jump from mysql 4 the other day, to take advantage of mysql’s new “INSERT … ON DUPLICATE UPDATE” command (which I think is spectacular by the way).

I didn’t want to actually upgrade from mysql4 to mysql5, just run the two mysqls side by side … so I looked around for a bit and figured out that all you need to do is get both  servers running on different ports. The trick is to remember to reference localhost:port (eg: “localhost:3307″) instead of just “localhost” whenever you connect to it, in php, for example. Below are screenshots of the things you need to watch out for when doing this on a windows machine.

The first part of the install is pretty straight forward, just make sure to install it into a different folder than your current mysql install.

At this screen be sure to tick the “Configure the MySQL Server now” box

Mysql5 configure the Mysql server now

At this screen pick “detailed configuration” and continue on …

Mysql5 detailed or standard configuration screen

mysql5 configure the mysql server 5.0 server instance

Mysql5 InnoDB Tablespace Settings

At this screen be sure to change the port number.

mysql5 please set the networking options

From the dropdown pick a service name that won’t conflict with the name of the service for the current MySQL install.

mysql5 set the windows options

mysql5 configure the mysql server 5.0 server

After that is all done, we want to try and connect to our brand new server. So fire up MySQL Administrator or MySQL query browser and create a new connection, like so … (Yes. I know running as root is bad for you … thanks).

mysql query browser new connection

Once you’re done … connect to MySql Query browser and you should go to this screen! The nice thing about this is that you can probably even run mysql 4, 4.1 and 5 all together.

voila … connected

Add comment February 4th, 2008


Recommended

Posts by Category

Calendar

February 2008
S M T W T F S
« Jan   Mar »
 12
3456789
10111213141516
17181920212223
242526272829  

Posts by Month