Professional Web Applications Themes

Upgrading MySQL - MySQL

Hi, I seem to be running Mysql 3.23. I want to upgrade to 5. I looked at the downloads page and cannot figure out which Linux version I should get....... I am running Red Hat 9.0. My box has Asus motherboard and an AMD chip....... Can someone please help and suggest which one I'm supposed to download and install? Thanks....

  1. #1

    Default Upgrading MySQL


    Hi,

    I seem to be running Mysql 3.23. I want to upgrade to 5. I looked at
    the downloads page and cannot figure out which Linux version I should
    get.......

    I am running Red Hat 9.0. My box has Asus motherboard and an AMD
    chip.......

    Can someone please help and suggest which one I'm supposed to download
    and install?

    Thanks.

    amerar@iwc.net Guest

  2. #2

    Default Re: Upgrading MySQL


    <amerariwc.net> wrote in message
    news:1138813895.046756.189990g14g2000cwa.googlegr oups.com...
    >
    > Hi,
    >
    > I seem to be running Mysql 3.23. I want to upgrade to 5. I looked at
    > the downloads page and cannot figure out which Linux version I should
    > get.......
    >
    > I am running Red Hat 9.0. My box has Asus motherboard and an AMD
    > chip.......
    I'll assume you have an 32-bit AMD chip. If you have an Opteron or other
    64-bit AMD chip, you'd need to use the MySQL distribution labelled for
    AMD64. Otherwise using the x86 distributions for Linux is fine.

    You can find out specific information about your CPU on Linux by this
    command:
    cat /proc/cpuinfo
    List of AMD 64-bit chips can be found here:
    [url]http://en.wikipedia.org/wiki/AMD64[/url]
    > Can someone please help and suggest which one I'm supposed to download
    > and install?
    Here's my recommendation:
    Linux (non RPM package) downloads:
    Linux (x86) ... Max 5.0.18

    The reason I don't favor using an RPM package on Redhat is that they have
    created so many interdependencies between RPM packages on their Linux system
    that it's virtually impossible to upgrade MySQL (or any single package)
    through the RPM method. At least, I've never been able to do it.

    The endorsed way to do it is to subscribe to the Redhat Network (which costs
    $$$) and upgrade all packages simultaneously. I assume the RHN does not
    offer MySQL 5 yet. But I cannot verify that, because there doesn't seem to
    be any information about current offerings from rhn.redhat.com.

    My solution would be to shut off the existing MySQL 3.23 daemon, install the
    current version of MySQL 5.0 from a non-RPM distribution, and then enable
    that. The RPM database will continue to believe it has MySQL 3.23
    installed, and since MySQL is mostly backward-compatible, the other packages
    that may use MySQL won't know the difference.

    One significant exception regarding backward compatibility between MySQL
    3.23 and 5.0 you should be aware of is doented here:
    [url]http://dev.mysql.com/doc/refman/5.0/en/old-client.html[/url]

    Regards,
    Bill K.


    Bill Karwin Guest

  3. #3

    Default upgrading MySQL

    I have MySQL 3.23.58 running. I would like to upgrade to 5.0.x
    Please provide some guidance.
    Thank you.

    [email]asuchit[/email]



    Suchit Ahuja Guest

  4. #4

    Default Re: upgrading MySQL

    Suchit Ahuja wrote:
    > I have MySQL 3.23.58 running. I would like to upgrade to 5.0.x
    > Please provide some guidance.
    Read, think about it, read and understand

    [url]http://dev.mysql.com/doc/refman/4.1/en/upgrade.html[/url]

    and the sub chapters then

    [url]http://dev.mysql.com/doc/refman/5.0/en/upgrade.html[/url]

    That should cover all MySQL related changes. Remember that you also
    might have to relink (or even recompile) your software that links
    against MySQL.

    HTH
    Kai

    --
    This signature is left as an exercise for the reader.
    Kai Ruhnau Guest

Similar Threads

  1. Upgrading CF 7.0.1 to CF 7.0.2
    By stomcavage in forum Coldfusion Server Administration
    Replies: 4
    Last Post: March 14th, 06:22 PM
  2. Replies: 2
    Last Post: February 14th, 10:54 AM
  3. Replies: 0
    Last Post: January 29th, 02:03 PM
  4. Will I lose data when upgrading MySQL?
    By bcr07548@creighton.edu in forum MySQL
    Replies: 4
    Last Post: January 14th, 08:30 PM
  5. Upgrading from 7.2 to 8.1
    By milkchaser in forum IBM DB2
    Replies: 4
    Last Post: August 29th, 04:49 PM

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