mysql upgrade

[Derick Centeno]

Interesting that you asked me that question.  Here's a professional 
examination by a bunch of engineers with their own lab to play in 
exploring just that issue of database function:

http://www.anandtech.com/printarticle.aspx?i=2520

It's a bit old now, but it's the facts!

Good Luck!

------------------------------------------------------------------------


Rodney Poplin wrote:
> Derick,
>
> Thank you. I have nothing on that machine yet so installing mysql 5 
> shouldnt be a problem. Then I can transfer over the database and all 
> should work (I hope lol).
>
> Can anyone verify that mysql runs faster on Linux than Os X? I was 
> told its a kernel issue with Os X that causes it to run slower.
>
> Also any recommendations for a machine thats only running a mysql 
> database? I have a G4 733 and a G5 iMac. I know the G5 is faster but 
> for running a database I cant see the benefits of it. Correct me if Im 
> wrong please.
> -----------------------------
> Thank you,
> Rodney Poplin
>
>
>
> On Sep 26, 2006, at 1:01 PM, Derick Centeno wrote:
>
>> Rodney,
>>
>> I went to those pages where the links were and read the 
>> documentation; just enough to participate in this conversation.
>> As I stated, my interpretation of those instructions explain between 
>> which versions of mysql one should upgrade from and to; as well as 
>> how to proceed.
>>
>> Regarding whether you should install mysql 5.0 or not, that depends 
>> on what mysql version you use currently.
>>
>> If you have not used mysql and there is no database in fact to worry 
>> about, then you should be able to just download and install mysql 5.0 
>> within YDL following their directions.  Then when YDL 5.0 comes out, 
>> just transfer the data there.  I have no idea if mysql 5.0 with be 
>> part of YDL 5 or not.  In any case, the directions provided on the 
>> mysql website as to how to handle all kinds of various transitions 
>> are there.
>>
>> If your situation is more complex than that, you will need to examine 
>> their website regarding how to proceed.
>>
>> Good Luck...
>> ------------------------------------------------------------------------
>>
>>
>> Rodney Poplin wrote:
>>> Derek,
>>>
>>> Thank you. That link wasnt there a few weeks ago or at least that I 
>>> remember. 
>>>
>>> So I cant install it? I have to upgrade first?
>>> -----------------------------
>>> Thank you,
>>> Rodney Poplin
>>>
>>>
>>>
>>> On Sep 26, 2006, at 12:07 PM, Derick Centeno wrote:
>>>
>>>> Rodney why not just go their website directly.  I found the page for 
>>>> Linux PowerPC here:
>>>>
>>>> http://dev.mysql.com/downloads/mysql/5.0.html
>>>>
>>>> Just scroll down, you can't miss it.
>>>>
>>>> You asked about upgrading mysql, according to how I read the 
>>>> documentation available at their website you will have to start 
>>>> from the 
>>>> version you have.  Here are those references:
>>>>
>>>> http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
>>>>
>>>> Note that this page begins with a link for upgrading from mysql 3.23 
>>>> which is the same version of mysql provided in YDL 4.1; hopefully that 
>>>> is good enough. 
>>>> The next link addresses upgrading from mysql 4.1 to 5.0:
>>>>
>>>> http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
>>>>
>>>> Be aware of the steps they recommend though -- there is no direct path 
>>>> to mysql 5.0, in other words one cannot go directly from mysql 3.23 to 
>>>> mysql 5.0!  So you and your team may have your work cut out for 
>>>> you; be 
>>>> sure to follow the upgrade steps as they have recommended.
>>>>
>>>> It is possible I may have misunderstood your message.  If you want 5.0 
>>>> for YDL (or any PowerPC system) the first link should be fine.
>>>>
>>>> Good Luck....
>>>> ------------------------------------------------------------------------
>>>>
>>>>
>>>> Rodney Poplin wrote:
>>>>> Anyone know how to upgrade the version of mysql to the newest version?
>>>>> Our company is trying to use YDL for hosting our database from OS X 
>>>>> for speed reasons but we are using ver 5 and YDL is shipping with 
>>>>> 3 so 
>>>>> we cant go backwards do to structure.
>>>>> -----------------------------
>>>>> Thank you,
>>>>> Rodney Poplin
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>>
>>>>> _______________________________________________
>>>>> yellowdog-newbie mailing list
>>>>> yellowdog-newbie at lists.terrasoftsolutions.com 
>>>>> <mailto:yellowdog-newbie at lists.terrasoftsolutions.com>
>>>>> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie
>>>>>
>>>> _______________________________________________
>>>> yellowdog-newbie mailing list
>>>> yellowdog-newbie at lists.terrasoftsolutions.com 
>>>> <mailto:yellowdog-newbie at lists.terrasoftsolutions.com>
>>>> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-newbie
>>>
>