Mysql May be close to releasing version 5

[mack]

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.

Full article here. [computerworld.com]

Mack.

[henry0]

Thanks Mack good finding

This leads me to the following question:

How does one perform seamlessly an upgrade?
Do a dump and a full reload which does not make sense
for current operations are to be stopped.

Or the best way which should be?

Obviously I never yet perform a "Live" upgrade on a server
since I use mostly managed server.
but for experiment purposes I am considering fully dedicted server.

[txbakers]

I haven't investigated it yet, but I think a dump/reload is going to be the only way. When I was using all myISAM tables it was easy just to copy the data directory from one server to the other.

With the innoDB tables it hasn't worked as well to build new schemas or backup dbs.

[mack]

In terms of exprting date to the new version, does anyone know what major differences there are that may pose problems?

Mack.

[coopster]

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.

[txbakers]

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.