Results 1 to 2 of 2
  1. #1

    Need advice on best way to Upgrade Win mySQL v4.1 to 5.1

    Hi,

    I am looking at upgrading my Servers mySQL v4.1 to 5.1 and was after some advice on the best way to do it.

    The servers are running Windows, so far I have this checked off to do

    1) Backup all databases
    2) Rename d:\mysql\data to d:\mysql\data_backup
    3) Download mySQL 5.0 extract to d:\mysql
    4) Update my.ini
    5) Start service
    6) Shutdown service
    7) rename d:\mysql\data to d:\mysql_datev5
    8) rename d:\mysql\data_backup d:\mysql\data
    9) start service - fingers crossed
    10) run mysql_upgrade command to upgrade all databases

    Check sites etc

    Then do same steps from 5.0 - 5.1

    If anyone has done this recently on a Windows server I would appreciate any idea you may have, also is 5.1.37 stable to use in production now?

    Thanks Aaron

  2. #2
    Join Date
    Sep 2007
    Posts
    368

    *

    Quote Originally Posted by blueskimonkey View Post
    Hi,

    I am looking at upgrading my Servers mySQL v4.1 to 5.1 and was after some advice on the best way to do it.

    The servers are running Windows, so far I have this checked off to do

    1) Backup all databases
    2) Rename d:\mysql\data to d:\mysql\data_backup
    3) Download mySQL 5.0 extract to d:\mysql
    4) Update my.ini
    5) Start service
    6) Shutdown service
    7) rename d:\mysql\data to d:\mysql_datev5
    8) rename d:\mysql\data_backup d:\mysql\data
    9) start service - fingers crossed
    10) run mysql_upgrade command to upgrade all databases

    Check sites etc

    Thanks Aaron
    Hi,

    All seems, ok did you upgrade?

Similar Threads

  1. Need advice on server upgrade
    By RJLee38 in forum Dedicated Server
    Replies: 19
    Last Post: 05-28-2009, 09:54 AM
  2. need your advice on this server upgrade
    By aapkae in forum Dedicated Server
    Replies: 7
    Last Post: 10-29-2007, 05:47 AM
  3. Advice for PC Upgrade
    By jhadley in forum Computers and Peripherals
    Replies: 3
    Last Post: 12-13-2006, 07:07 PM
  4. Computer Upgrade Advice
    By csparks in forum Web Hosting Lounge
    Replies: 0
    Last Post: 03-07-2004, 11:51 AM
  5. Problem with /var/lib/mysql/mysql.sock after MySQL upgrade
    By oldford in forum Dedicated Server
    Replies: 9
    Last Post: 07-30-2003, 11:35 AM

Posting Permissions

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