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

7.5.1 and mySQL v4 upgrade

Discussion in 'Plesk for Linux - 8.x and Older' started by Adam2020, Dec 27, 2004.

  1. Adam2020

    Adam2020 Guest

    0
     
    We are primarily an Ensim shop but recently started rolling out Plesk on some of our new servers. There are some things I like about Plesk, but others still make hair on my back stand when I think about them (no server-wide backup option for all domains, site backups take sites off-line, etc).

    But, here's one I can't get a straight answer from Plesk support. Brand new install, Plesk 7.5.1/Reloaded on Fedora Core 1. Want to upgrade mySQL 3.23 to 4.x. mySQL 4 has been out for what, over a year now? Well over a year, if my memory serves me right. We've been offering our hosting clients mySQL 4 on Ensim for a very long time, and need to offer the same on Plesk servers. What is the procedure for upgrading mySQL to v4, so that all sites can see and recognize the new version? I'm sure it's a little different than on Ensim servers where you need to run pre and post maintenance scripts that copy the new settings to each site, but... Plesk support won't say one way or another how this upgrade can be applied... if at all. Do I just install standard mySQL RPMs and Plesk takes care of the rest? How much is Plesk tied to the system, OS, packages, etc, and how much can be done independently of the Plesk control panel? Is it anywhere as flexible as say Webmin where you can install things from shell (RPMs, etc) and the web control panel just works with whatever is there, or....???

    Thanks!
     
  2. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    Try to use YUM to upgrade from http://www.atomicrocketturtle.com/


    After upgrade use : /usr/bin/mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`
     
  3. Cranky

    Cranky Guest

    0
     
    Apart from qmail and courier-imap it's independant ... you can run any apache 2.x, php, etc. and Plesk won't complain and will work happily with them.
     
  4. Adam2020

    Adam2020 Guest

    0
     
    Okay, this is what I did.

    Downloaded the following files:

    mysql-4.0.22-2.rhfc1.art.i386.rpm
    mysql-compat-4.0.22-2.rhfc1.art.i386.rpm
    mysql-devel-4.0.22-2.rhfc1.art.i386.rpm
    mysql-server-4.0.22-2.rhfc1.art.i386.rpm

    and installed them with:

    rpm -Fvh *.rpm

    Restarted mySQL. mysql -V shows correctly v4.22 as running.

    I then run:

    /usr/bin/mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`

    as suggested by lvalics. Came up with couple errors about non-existing tables or columns, but nothing critical (that I could tell).

    When I access DB WebAdmin through Plesk (7.5.1), it comes up with phpMyAdmin 2.6.0-pl3 and mySQL 4.0.22

    Everything APPEARS to be working. If anyone has any comments or would like to mention something that I may have missed - please do let me know!

    Thanks.
     
  5. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    I'm glad that I helped you.
    Just don't forget to update your my.cnf :)
     
  6. Adam2020

    Adam2020 Guest

    0
     
    Okay, give me a hint... what do I need to update in my.cnf?

    :)

    On my other servers (Ensim with mySQL4) I did tweak some of the specs for performance reasons. Is there something I need to do on Plesk, outside of these tweaks? Any pointers, how-to's, or documentation you can point me at? Or an example?

    Thanks!
     
  7. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    I changed my sugnature, now is inside my signature some links. Hope this help.
     
Loading...