MySQL has just released version 5 of their database engine.

The server's chugging along just fine after the previous upgrade. I always welcome a bit of time to play with the new toys, especially when I feel I have some time. The gig I'm on is very low pressure, giving me plenty of time to do the upgrade.

I've had a look at the features and it looks like the SAP push to integrate their stuff into the mainstream release has paid off. Triggers, views, stored procedures (albeit basic), and some of the other bits intrigue me.

What I have works, and is only a few months old. What I had before that worked, and did so for two years. The upgrade to 5.0 may break some of the bits that are relied on, the least of which are the PHP connector that this web log software uses and the Java connector that the other parts of this site use. Plus, I got stung a little by the changes to passwords (the connectors forced me to force the server to use old-school encryption...not that it really matters, the server's behind a firewall and doesn't accept connections except from my systems) and some of the data structures.

Additionally, moving from 3 to 4 was a pain with the dump and restore as the dump didn't respect table relationships (saving alphabetically instead), forcing me to edit the dump file to create the tables and insert the data in the correct order. In a lurch, I imagined, it was better to have that than nothing.

Finally, I have to check-out the web-based administration. The Webmin software used now might not like v5 syntax changes.

At least I'll have something to do for a while...