homepage Welcome to WebmasterWorld Guest from 174.129.76.87
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Upgrading from mysql 4.0.27
ianevans

10+ Year Member



 
Msg#: 4087501 posted 1:17 am on Feb 26, 2010 (gmt 0)

Our website has been chugging along nicely for years running mysql 4.0.27 when I suddenly thought it might be high time to upgrade into the present.

Of course the suggested upgrade path to 5.x from 4.0.x is to upgrade to 4.1 first and then to 5.x

But of course mysql just ended support for 4.x and I can't find its downloads on their site.

Is it safe to assume that since my database is just being used to serve up content and not handling stuff like ecommerce transactions or, I dunno, air traffic control, that my upgrade path would be like this:

Take the site down for maintenance (returning search engine friendly 503 error codes).

Export my site's content tables with mysqldump.

Eradicate mysql 4.0.27 from the server.

With no mysql around, do a clean install of mysql 5.x.

Create the users and then import my site's tables?

 

rocknbil

WebmasterWorld Senior Member rocknbil us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 4087501 posted 6:00 pm on Feb 26, 2010 (gmt 0)

Not sure on the install. You should be able to just install 5+ and go with it, but don't quote me on that . . .

One thing I do know for sure is you will **probably** encounter this problem [dev.mysql.com]. After creating users for the DB, you will have to execute, from the command line,

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

lammert

WebmasterWorld Senior Member lammert us a WebmasterWorld Top Contributor of All Time 5+ Year Member



 
Msg#: 4087501 posted 12:37 am on Mar 11, 2010 (gmt 0)

Yes, the changed password encryption method is the main problem when doing the jump from 4.0 to 5.x. You should try to use the new password method as it is more secure then the previous one.

My advice would be to first install 5.x, and only when everything works flawlessly remove 4.0.27. In that way it is less stressful to go back to a working situation in case the upgrade doesn't work as expected. Two MySQL versions should be able to coexist as long as you assign different TCP/IP port numbers to each of the instances and use separate data directories.

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