Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Regular Coder
    Join Date
    Sep 2002
    Location
    Adelaide, Australia
    Posts
    472
    Thanks
    3
    Thanked 0 Times in 0 Posts

    upgrading from 4.1.8

    Hey there,

    I can't seem to find any good documentation online to help me upgrade on a W2k3 box MySQL 4.1.8 to the latest 5 version.

    Any hints?

    Cheers

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,184
    Thanks
    75
    Thanked 4,340 Times in 4,306 Posts
    The safest way to do this is simply do a full database dump (mysqldump utility) from the 4.1 version. Uninstall 4.1. Install 5.5. Run mysql < thedump.sql to rebuild everything.

    If your DB is especially large, you might want to dump it by tables. One at at time or a few at a time. mysqldump --help will give you full list of options you can use.

    I did this (several years ago now) and had no problems at all.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #3
    Regular Coder
    Join Date
    Sep 2002
    Location
    Adelaide, Australia
    Posts
    472
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks. I guess I could also test it by importing the dump on a fresh install on another box as well.

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,184
    Thanks
    75
    Thanked 4,340 Times in 4,306 Posts
    Absolutely the best thing to do if you can!

    I figured the worst that could happen would be that I'd reinstall 4.1, because I didn't have another box, but neither did I have problems.

    But if I'd had one, I sure would have done it your way.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #5
    Senior Coder djm0219's Avatar
    Join Date
    Aug 2003
    Location
    Wake Forest, North Carolina
    Posts
    1,294
    Thanks
    4
    Thanked 203 Times in 200 Posts
    FWIW I get the ZIP file of a new version and simply replace the current directory structure with the new one after unzipping the new version. I usually make a copy of the database directory just in case but, so far, have not had any issues with the "mass replace" approach.
    Dave .... HostMonster for all of your hosting needs


  •  

    Posting Permissions

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