Nice one MySQL

February 3, 2011 at 9:18 am | Posted in Performance | 2 Comments
Tags: ,

I don’t use MySQL much, my experience is very much in the Oracle area with SQL Server a close second. This is not surprising as Oracle and SQL Server are the primary databases used with Documentum and MySQL isn’t even supported for Documentum Content Server. However from time to time I need to use it.

I was running the Windows-based installer for a MySQL installation and ran through the installation screens pretty quickly and started the installation. All in all this took only a few minutes, however right at the end I got an error message about being unable to apply security settings. For a moment my heart sank as I could see that a job that seemed like would be completed very quickly would now involve possibly hours of internet trawling, re-installation and so on. However as I read the accompanying dialog box it told me that if I was re-installing after uninstalling then my previous data directory would still be there and would have the old password set; I needed to simply skip the final step and go to to the configuration program and re-do the configuration. I had indeed just uninstalled and the solution offered fixed my problem immediately.

Great work by the MySQL installation team – if only other product installer were quite so helpful. I’m guessing here that this was a problem that had been reported, a workaround identified and then someone had seen fit to add the solution into the installation process itself.

Advertisements

2 Comments »

RSS feed for comments on this post. TrackBack URI

  1. Yeah, but if commercial installers were that helpful then they wouldn’t need consultants to install them… 😉

    As a former colleague used to say “If it was easy, we wouldn’t have jobs.”

    • I know that there was a hint of irony in that reply however some people do actually think like that which is a bit depressing. I would encourage anyone who does think like that to read Andrew McAfee‘s blog entry that has some relevance to such thinking. If what holds true for coal and CPUs also holds for computing projects generally then improving installers and thus lowering the cost of a project should result in more work not less. Good consultants will benefit.


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: