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 4.1 or 5.0 on 7.5.4?

Discussion in 'Plesk for Linux - 8.x and Older' started by robert8450, Dec 2, 2005.

  1. robert8450

    robert8450 Guest

    0
     
    How do I determine which mysql will safely work with plesk?

    I currently have plesk 7.5.4 which was just upgraded last night from 7.5.3 because I was informed by a nice lady from the plesk staff that upgrading to 7.5.4 should also upgrade the mysql.

    Well either the auto installer did not work properly (though it seems to have upgraded everything else just fine) becuase I still have mysql 4.0, or I was misinformed or misunderstood.

    Regardless, running the autoinstaller did not upgrade mysql 4.0 and I need to get that up to at least mysql 4.1 as I have a new customer that was previously using cpanel & mysql 4.1 and we cannot recover any of his DB backups as they were created with 4.1 on the cpanel system

    Therefore, How do I determine the best and safest mysql installation to update the current mysql 4.0 that I have?

    From the MySQL website, they suggest that MySQL 5.0 is the most recent STABLE release yet when upgrading, you should stay in the same series (and in this case that would be 4.1)

    http://dev.mysql.com/doc/refman/5.0/en/choosing-version.html

    However they do not say if it is compatible with plesk or not. So, if it is possible without causing any problems, I would like to upgrade my plesk 7.5.4 to MySQL 5.0 but I don't need any more problems so can you suggest the best and safest mySQL to upgrade to?

    Thank you for your time to read and understand this request.

    PS Just in case you need more information to make a decision or post a reply, please consider the following: We have two servers, one is a Celeron with SUSE linux 9.1 and the other is an Intel P4 with hyperthreading and SUSE Linux 9.1 Both have 1GB RAM and sufficient HD space and both have Plesk installed.
     
  2. tmonsen

    tmonsen Guest

    0
     
    Robert,

    I watch the forums fairly closely, from what I've read, getting mysql 5 to work with plesk is difficult (I don't know that I've seen anyone post that they have installed it successfully, but could be wrong). This may not be a problem if you are only running your own code, but many of the applications that work with plesk, have not been upgraded to work with 5.0. Hope the additional info helps.
     
  3. robert8450

    robert8450 Guest

    0
     
    thank you tmonsen,

    From reading more of the MySQL website http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html I think I will probably have to agree with you that upgrading 4.0 to 5.0 is going to be a problem for me since I am a novice.

    Acording to their website and from my limited understanding of this process, upgrading from 4.0 to 4.1 can be somewhat tricky. I think I am going to see if I can hire someone to do this for me. Because I don't want to break 120+ websites just for one new customer.

    I may even just get a new Cpanel server with 4.1 or 5.0 already installed on it and put some customers there as opposed to breaking my primary & secondary servers.

    Any input that I could get from the SWSoft staff right now about this would be greatly appreciated please.

    thank you.
     
  4. robert8450

    robert8450 Guest

    0
     
    I submitted a trouble ticket about this and here is the response I got in case it may help the next person:

    to which I replied,

    Ok thank you for letting me know that mysql 5.0 is not supported in Plesk 7.5.4 Will mysql 4.1 safely work with 7.5.4? and was the auto-installer that I ran suppose to automatically update mysql 4.0 when I upgraded from 7.5.3 to 7.5.4?

    thank you for your help.

    ***UPDATE***

    Here is the response I just got back from plesk technical support:

    Well, that answers that. Have you guys had pretty good luck upgrading mysql 4.0 to 4.1 on your Plesk 7.5.4 machines?
     
  5. mian

    mian Guest

    0
     
    yeah 4.1 rpm's from art works fine, for more info do a search many have done it.
     
Loading...