Professional Web Applications Themes

Upgrading from 4.0 to 4.1 - MySQL

Hi, I don't seem to be able to find an upgrade doent for 4.0 to 4.1. It simply says remove version 4.0 and install 4.1 I don't really want to do that as I am sure I must backup at the very least my database(s). But then I also need to backup my 'ini' file. What else do I need to save/backup/do? Many thanks. Simon...

  1. #1

    Default Upgrading from 4.0 to 4.1

    Hi,

    I don't seem to be able to find an upgrade doent for 4.0 to 4.1.

    It simply says remove version 4.0 and install 4.1

    I don't really want to do that as I am sure I must backup at the very least
    my database(s).
    But then I also need to backup my 'ini' file.

    What else do I need to save/backup/do?

    Many thanks.

    Simon


    Simon Guest

  2. #2

    Default Re: Upgrading from 4.0 to 4.1

    "Simon" <spambucketexample.com> wrote:
    >
    > I don't seem to be able to find an upgrade doent for 4.0 to 4.1.
    It's part of the official manual:

    <http://dev.mysql.com/doc/refman/4.1/en/upgrade.html>
    > What else do I need to save/backup/do?
    Read and *understand* (this is not optional) about new character
    encoding stuff in 4.1. Probably you have to do some refactoring
    in your application(s) to avoid character set problems.


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

    Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
    MySQL User Forums: [url]http://forums.mysql.com/[/url]
    Axel Schwenke Guest

  3. #3

    Default Re: Upgrading from 4.0 to 4.1

    "Axel Schwenke" <axel.schwenkegmx.de> wrote in message
    news:f3oevd.m19.lnidefix.xl.local...
    > <http://dev.mysql.com/doc/refman/4.1/en/upgrade.html>
    >
    >> What else do I need to save/backup/do?
    >
    > Read and *understand* (this is not optional) about new character
    > encoding stuff in 4.1. Probably you have to do some refactoring
    > in your application(s) to avoid character set problems.
    Another gotcha between 4.0 and 4.1: passwords for MySQL accounts are
    incompatible between these two versions. You should run 4.1
    with --old-passwords, or else you have to reset all accounts' passwords.

    See [url]http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html[/url] and
    [url]http://dev.mysql.com/doc/refman/4.1/en/old-client.html[/url]

    Regards,
    Bill K.


    Bill Karwin Guest

  4. #4

    Default Re: Upgrading from 4.0 to 4.1

    >>
    >> I don't seem to be able to find an upgrade doent for 4.0 to 4.1.
    >
    > It's part of the official manual:
    >
    > <http://dev.mysql.com/doc/refman/4.1/en/upgrade.html>
    >
    >> What else do I need to save/backup/do?
    >
    > Read and *understand* (this is not optional) about new character
    > encoding stuff in 4.1. Probably you have to do some refactoring
    > in your application(s) to avoid character set problems.
    >
    Thanks

    I am using the same data for development on 2 servers, and 1 'live' server.
    2 of them are 4.1, (1 dev and 1 live), the other dev is 4.0.

    The 4.0 is a development machine so I usually dump the data from the live
    machine and upload it to the 4.0 development machine, (I do the same with
    the 4.1 machine but not very often as it is not used for data tests).

    So it is safe to assume that I have been
    1- Somewhat lucky never to run into troubles
    2- Almost certainly not using MySql to it's full potential
    3- All the test results I have come to are not really useful as 4.0 and 4.1
    are so different.

    If I have been lucky then I guess I could remove 4.0 from the dev machine,
    install 4.1 and upload the data again.
    All I really need to do is save my current passwords, (so I can set them to
    the same on the new install), reload the backup data from the 4.1 machines
    and I should be ok.

    What do you think?

    Simon


    Simon Guest

Similar Threads

  1. Upgrading CF from 5 to 7
    By hkb_101_101 in forum Coldfusion Server Administration
    Replies: 0
    Last Post: September 20th, 07:02 AM
  2. Upgrading from 4.5 to MX7
    By gomango in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: April 20th, 02:47 PM
  3. Upgrading to IDS 9.3 / 9.4
    By tomL in forum Informix
    Replies: 0
    Last Post: October 10th, 07:02 PM
  4. Upgrading from PE to PE2
    By Chuck Snyder in forum Adobe Photoshop Elements
    Replies: 4
    Last Post: August 16th, 11:12 PM
  5. upgrading from ME to XP
    By Rick \Nutcase\ Rogers in forum Windows XP/2000/ME
    Replies: 0
    Last Post: July 1st, 02:04 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139