Mysql have already made available a release, that many see as the final test version prior to the full blown distribution of version 5 of the popular database server.
It is now thought that if no major flaws or bugs are found in the current release candidate then Mysql version 5 may be released as early as November 05.
The company is calling Version 5 its most significant upgrade yet. It adds a handful of features considered important for enterprises that have long been available from market leaders Oracle Corp., IBM and Microsoft Corp. Chief among them are triggers, views and stored procedures.
The new version of Mysql will remain GPL'd. Mysql will continue to offer support options for commercial customers.
On one of my text boxes it was as easy as using the same data directory, no dumping/restoring, no conversions. Note, the particular box did not include any InnoDB tables so I cannot offer any experience there ... yet.
I've installed 5 and it looks very good so far. But I'm still faced with the backup/restore issue. If I use the SQL based backup the text files are too huge to restore! At least through the mySQL gui tools. Maybe a command line would be better.