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

MySQL 5?

Discussion in 'Plesk for Linux - 8.x and Older' started by Jamai2, Dec 1, 2006.

  1. Jamai2

    Jamai2 Guest

    0
     
    8.1 looks great, small update but also a nice set of new capabilities.

    It now supports MySQL 5.0 as well. Does anybody have a foolproof upgrade-guide for upgrading from Mysql 4.1.21 to 5?
     
  2. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    What OS are you on?
     
  3. Jamai2

    Jamai2 Guest

    0
     
    I have a few servers, from Fedora Core 2 to core 4.
     
  4. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    Atomic Rocket Turtle has rpms for MySQL 5 in his atomic-bleeding repository, but as the repository name says these are not yet considered tested enough for production use. You can test them on a test install of course.
     
  5. Dawn

    Dawn Guest

    0
     
    Is there a guide how to upgrade MySQL 4 to MySQL 5. I'm using Debian Sarge. I know DotDeb has some rpm's but I don't know what's the best an cleanest way to migrate to MySQL 5 with Debian Sarge.

    Greets and best regards,
    Dawn
     
  6. DCoats

    DCoats Guest

    0
     
    I had mysql5 installed on freebsd5.5 and the autoinstaller made me remove the port before it could install mysql4 can I override this somewhere and force it to use the mysql5 port? I realize I can edit the /usr/ports/swsoft/psa/Makefile but has anyone done this , do we know if it causes any issues?
     
  7. Inno

    Inno Guest

    0
     
  8. Dawn

    Dawn Guest

    0
     
    Thanks for your answer. But is there a solution for Debian too? I know where I can get the .deb's but I don't know how to install it without "killing" my server ;)

    Greets,
    Dawn
     
  9. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    Why would the upgrade kill your server?
     
  10. Inno

    Inno Guest

    0
     
    I never worked with Debian. Can't say. Is there really nothing to find via Google? It is a hot item so I suppose there must be other boards where you can find relevant information.

    If you find something, please post the link. If we can, we'll surely give our opinion. It can't be that hard to find an answer.
     
  11. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    It seems the majority of Plesk users are using an .rpm based distribution, so info for .deb based distro's info is probably harder to find.
     
  12. Dawn

    Dawn Guest

    0
     
    I'm scared about upgrading because plesk stores it's data in the mysql database so I'm a little bit carefull.

    I've googled around the net for a longer time and searched for "debian plesk mysql 5" but I couln't find any usefull information for this pupose.

    It would be very kind of you if you can explain me how to do that.

    Greets and best regards,
    Dawn
     
  13. danliker

    danliker Silver Pleskian Plesk Certified Professional

    33
    43%
    Joined:
    Feb 15, 2006
    Messages:
    575
    Likes Received:
    0
    Location:
    Switzerland
    for debian you can use the dotdeb packages, but i have not testet it now...

    http://dotdeb.org/
     
  14. Vengent

    Vengent Guest

    0
     
    I just upgraded my sarge box to php5 and mysql5 with plesk 8.1 using dotdeb recently.

    I'm afraid I didn't keep up with all the exact steps, but generally speaking I made a backup of the psa database, then installed the packages from dotdeb.

    Didn't have many problems with mysql5.

    Php5 on the other hand was a challenge and a half, but is all existing comfortably together now.

    All hail debian!
     
  15. Dawn

    Dawn Guest

    0
     
    I got PHP 5 working. Had some problems with a few modules but now it fully works.

    But I don't know enough about a MySQL 5 Upgrade. Can you please post you exact steps how you did it? I'm doing a full server backup every day but it would be nice if I don't need it ;) Would be very kind of you and I think you'll make a lot of Debian addicts happy...

    Greets and best regards,
    Dawn
     
  16. Vengent

    Vengent Guest

    0
     
    I'll set up a test box and try it again to document it. I been wanting to do it anyways, as I need to figure out how to upgrade everything to etch next, but made the mistake of upgrading my test boxes to etch before installing plesk and not about to risk another re-install on the production box.
     
  17. Dawn

    Dawn Guest

    0
     
    Oh nice :) I hope you'll be more lucky the next time...

    Btw: Do you see any chance when etch stable is out to upgrade a running server where plesk is allreay installed?

    Big THX,
    Dawn
     
  18. Vengent

    Vengent Guest

    0
     
    I hope so, but depends on other plesk dependencies. I intend to try on this test box (with etch rc3) once I do the php5/mysql5 upgrade.
     
  19. Dawn

    Dawn Guest

    0
     
    Sounds really nice :) Often I think there aren't many Plesk-Hosters out there which use Debian... Let me know if I can help you someting.

    Greets,
    Dawn
     
  20. VIB-host

    VIB-host Guest

    0
     
    any exspirience upgrading FreeBSD6 MySql 4.x to MySql 5.x and maybe some step by step guide?
     
Loading...