SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2003
    Location
    Boston
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to upgrade mysql?

    hello, I need to upgrade mysql 4.0 to mysql to 4.1.
    I have been looking for instruction on how to do it, but did not found any.

    Could you help me please.

  2. #2
    SitePoint Enthusiast
    Join Date
    Aug 2002
    Location
    Barcelona
    Posts
    43
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The MySQL site has instructions: http://dev.mysql.com/doc/mysql/en/up...-from-4-0.html

    But watch out! There are two big problems that I had.
    First was to do with users and passwords - there's a new password storage algorithm in 4.1, that totally screws old pÓsswords, so you need to reset old passwords (http://dev.mysql.com/doc/mysql/en/password-hashing.html)

    Second, some data tables just wouldn't work right after the upgrade, don't know what MySQL did to them, but I could not read the contents at all. I had to delete the tables, and restore them from a backup SQL file :-(

    So best suggestion before you start is: back up your database first, into an SQL dump file!
    Juddster


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •