1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How do I upgrade current MySQL v3.x to v4.x via Updater

Discussion in 'Plesk for Linux - 8.x and Older' started by tcong, Mar 30, 2006.

  1. tcong

    tcong Guest

    0
     
    Wonder who do I perform an upgrade of MySQL server to v4.1.x using Plesk Updater?

    Is there any other simplier method other than binary install using root command prompt?

    >>
    Fedora Core 2, Plesk 8.0.0, MySQL 3.28.x
     
  2. eilko

    eilko Regular Pleskian

    28
    73%
    Joined:
    Aug 1, 2001
    Messages:
    468
    Likes Received:
    4
    Location:
    Enschede, Netherlands
    you can't update mysql by the plesk updater, you need an update of mysql by yum or up2date
     
  3. tcong

    tcong Guest

    0
     
    Will it be safe enough such that it will cause server downtime? Or Up2date will be quite an automatic update?

    I mean, will Up2date detect Plesk default mysql installed location?
     
  4. Highland

    Highland Guest

    0
     
    I'm going to assume you have Yum installed. If you don't, go get it.

    Edit your yum.conf file (usually in the /etc directory) and add the following lines

    Now run
    Code:
    #yum check-update
    You should see some mysql packages listed in there (current ART release is 4.1.18)
    Now we run
    Code:
    #yum upgrade mysql
    If you are upgrading from any version prior to 4.1.x you then need to edit /etc/my.cnf and add this line under [mysqld]
    Code:
    old_passwords=1
    Restart mysql and you should be set with 4.1.18 without problems
     
  5. dimensions

    dimensions Basic Pleskian

    24
    57%
    Joined:
    Aug 28, 2002
    Messages:
    50
    Likes Received:
    0
    Cant fine Yum.conf

    I cant find yum.conf in my /etc folder?
    How do i get it?
     
  6. Highland

    Highland Guest

    0
     
    Do you have Yum installed?

    #rpm -q yum
     
  7. ashwin_acharya

    ashwin_acharya Guest

    0
     
    Hi,

    Iam upgrading mysql on plesk 7.5.x platform iwouldliketoknow whetherto edit my.cnf after upgrading or before doing it.

    Sorry for dum que but pleaseletme know.

    Thanks

    Ashwin
     
  8. Highland

    Highland Guest

    0
     
    Edit it after upgrading. Be sure to restart mysql after you do.
     
  9. ColdFire

    ColdFire Guest

    0
     
    Just a few words to say that this procedure works fine. I've a plesk 8 on FC2, and I upgraded MySQL from 3.2x to 4.x with yum successfully.
     
  10. Bavarius

    Bavarius Guest

    0
     
    Thanks for the great description!

    Unfortunately, I can now no longer start MySQL!
    brings: "A timeout error occurred trying to start MySQL Daemon"

    I read somewhere else that one cannot do that at root level (I a logged in as root via Putty). What else should I do (from another site I read we should log in as user mysql but what password would that be??)

    Can you please help me? Many thanks!
     
Loading...