First of all, do you see any problems with this approach? Second, how would I reproduce this in MSSQL?

It seems that the preference pane will not work to start or stop MySQL yet so you will have to start it manually from the command line and create a link to the socket file.

First, start MySQL in a terminal window with the following command:

Then either close the terminal and open a new one, or just hit Command-N to open a new terminal window. Then type the following:

And lastly, create a symbolic link to point the default socket file:

I will update this post with info on how to get it going with Lingon

Noooo!!! MySQL Do not like it one bit. So I had to revert to the docs and there it was:

The DEFAULT clause specifies a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column.

Link: http://dev.mysql.com/doc/refman/5.0/en/create-table.html

So please take note on this issue if you just spend 20 minutes like me, trying to figure it out.

Hope this helps.

1) Donwload the JDBC drivers from here: http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.11.zip/from/pick

2) Extract the archive and copy the following file: mysql-connector-java-3.1.11-bin.jar to the following destination:

J2EE {j2ee path}/servers/lib

If you want it available to all servers or just for the Coldfusion app then: {cfmx instance path}/cfusion-ear/cfusion-war/WEB-INF/lib

Standalone {cfmx path}/wwwroot/WEB-INF/lib

3) Restart your CFMX instance or server.

4) Go to your Datasources in your coldfusion administrator to register a new datasource:

Name: {Your datasource name}
JDBC URL: jdbc:mysql://{your host}:3306/{your database}
Driver Class: com.mysql.jdbc.Driver
Driver Name: MySQL 5.0
User Name: {Username}
Password: {Your Password}

And that is it.

MySQL Install Dir:

/opt/mysql-standard-5.0.13

MySQL Link

/usr/local/mysql ==> /opt/mysql-standard-5.0.13

To upgrade to the new release, I downloaded the Linux (x86, glibc-2.3, dynamic, gcc) Standard Binary

I then extracted the archive to the following location:

/opt/mysql-standard-5.0.15

I continued to copy all of my data folder from my previous install to the new install. Now I fired up a terminal to fix the permission, groups and ownerships following the readme. Below is what you need to do:

shell> cd to /usr/local/mysql

shell> chown -R root .

shell> chown -R mysql data

shell> chgrp -R mysql .

The first command changes the owner attribute of the files to the `root' user. The second changes the owner attribute of the data directory to the `mysql' user. The third changes the group attribute to the `mysql' group.

I then proceed to startup my database. I use webmin, if not just type in the following command:

shell> bin/mysqld_safe --user=mysql &

Everything should be working great now. However, my InnoDB structure databases are somehow "FLOPPED." For some reason, which I still have not been able to figure out, the tables are not working. So a simple workaround, is just to do a simple backup of your InnoDB databases using the MySQL Administrator and then importing them back to the new install. This actually is the approach that the MySQL manual advices.

So there it is, simple, yea right!! MySQL Upgrade.