1. Hi there, Guest

    Only registered users can really experience what DLP has to offer. Many forums are only accessible if you have an account. Why don't you register?
    Dismiss Notice

MySQL Upgrade

Discussion in 'Announcements' started by Lord Ravenclaw, Aug 2, 2006.

0/5, 0 votes
  1. Lord Ravenclaw

    Lord Ravenclaw DLP Overlord Admin DLP Supporter

    Joined:
    Apr 2, 2005
    Messages:
    4,376
    Location:
    Denver, CO
    Aug 2, 2006 #1
    Tonight at 3am EST I did a MySQL upgrade. This moved us from MySQL 4.1.20 to MySQL 5.0.21 (to be moved forward to .22 soon). It was a rather major upgrade and the last time I tried MySQL 5 (5.0.6) I think you old members remember when errors would pop up (back on phpBB) stating that tables were corrupt. In light of this I've made sure proper backups were made and all precautions taken. Enjoy (though most of the benefit is for me :D).

    Also, how'd you like my maintenance page? =)
     
  2. Skeletaure

    Skeletaure Magical Core Enthusiast ~ Prestige ~ DLP Supporter

    Joined:
    Mar 5, 2006
    Messages:
    2,895
    Location:
    United Kingdom
    High Score:
    13,152
    Aug 2, 2006 #2
    LOL, the "intelligent, cunning and beautiful Lord Ravenclaw". Very nice.
     
  3. Lord Ravenclaw

    Lord Ravenclaw DLP Overlord Admin DLP Supporter

    Joined:
    Apr 2, 2005
    Messages:
    4,376
    Location:
    Denver, CO
    Aug 2, 2006 #3
    ...and apparently 5.0.21 had a bug which reacted with vBulletin badly. I could have either patched vB or upgraded MySQL, I chose the latter. We're now running MySQL 5.0.22.

    And MySQL 5.0.22 was just a security release, so the bugfix is slated for MySQL 5.0.23. I've patched the forums in the mean time which fixed the problem from this side.
     
  4. Jon

    Jon The Demon Mayor Admin DLP Supporter

    Joined:
    Jun 5, 2006
    Messages:
    8,024
    Location:
    Australia
    Aug 2, 2006 #4
    Raven ftw.
     
  5. Lord Ravenclaw

    Lord Ravenclaw DLP Overlord Admin DLP Supporter

    Joined:
    Apr 2, 2005
    Messages:
    4,376
    Location:
    Denver, CO
    Aug 4, 2006 #5
    Moved to MySQL 5.0.24. Works great, other than a slight problem during the upgrade. I was able to revert the changes to vBulletin as well as the bug is fixed in MySQL 5.0.24.