Upgrade MySQL to last version

Posted on 2011-05-03
Last Modified: 2012-06-27
Im using MySQL 4.1 and Coldfusion 9 on a windows machine, I want to upgrade to the lastest version can someone walk me through this or tell me where I can find the steps?

Question by:overcolor
    LVL 24

    Accepted Solution

    best advise is from the mysql web site

    if you just have myisam tables, they can be copied (as files) fairly easily. innodb takes a bit more work.

    one simple walkthrough is this

    1. backup
    2. use mysqldump to convert your whole db into sql statements (including all accounts and permissions)
    3. stop the old server and completely uninstall it
    4. install the new server and start it running
    5. feed it the giant sql file you made
    LVL 23

    Expert Comment

    - i would suggest you to follow the mysql documented manuals which is to upgrade from 4.1 to 5.0 first, then from 5.0 to 5.1 (latest):

    - mysql also have prepared sets of checklist prior to the upgrade on windows. do read the comments section too as there are valuable tips:
    LVL 23

    Expert Comment

    - does upgrade it directly from 4.1 to 5. works for you?

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
    This video discusses moving either the default database or any database to a new volume.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now