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. #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    29,698
    Thanks
    93
    Thanked 4,947 Times in 4,908 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.
    Be yourself. No one else is as qualified.

  3. #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. #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    29,698
    Thanks
    93
    Thanked 4,947 Times in 4,908 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.
    Be yourself. No one else is as qualified.

  5. #5
    Senior Coder djm0219's Avatar
    Join Date
    Aug 2003
    Location
    North Carolina
    Posts
    1,425
    Thanks
    4
    Thanked 224 Times in 221 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
  •