homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Mysql May be close to releasing version 5

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

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]




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

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.


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

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.


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

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



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

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.


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

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.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved