Welcome to WebmasterWorld Guest from 54.196.238.210

Forum Moderators: open

Message Too Old, No Replies

Mysql May be close to releasing version 5

     

mack

10:12 pm on Oct 12, 2005 (gmt 0)

WebmasterWorld Administrator mack is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



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

12:07 pm on Oct 15, 2005 (gmt 0)

WebmasterWorld Senior Member henry0 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

12:39 pm on Oct 15, 2005 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

2:04 pm on Oct 15, 2005 (gmt 0)

WebmasterWorld Administrator mack is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



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

Mack.

coopster

12:40 am on Oct 17, 2005 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

12:58 am on Oct 25, 2005 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month