[WBEL-users] MySQL 4.0

[Karanbir Singh]

The point I was trying to make was that if you have live data running on 
the machine, follow the upgrade path laid out on that link I posted, 
dont just force an upgrade on the software - the data needs a bit of 
working on as well. If you dont have any live data, and are looking to 
setup MySQL 4, your best bet is to install a fresh version rather than 
upgrade.

Joe Brouhard wrote:

>>hey!
>>
>>Unless you have absolutely no data setup / running with MySQL 3, you
>>might get away with a forced upgrade, otherwise your database is going
>>to break. ( and security issues are goign to get shot to hell ).
>>
>>take a look : http://www.mysql.com/doc/en/Upgrading-from-3.23.html
>>
>>    
>>
>
>I've had no problems with this in the past.  Absolutely *NONE* - 
>The only problems according to the link you have provided revolve around security-related stuff (ISAM versus MyISAM, and so forth). 
>
>
>  
>
... and the shared lib's that caused me some issues ( had to recompile 
php ) ....

>>best bet, for a new install - remove the previous Mysql from your system
>>and do a fresh rpm -i  for MySQL 4.
>>
>>    
>>
>
>On production boxes, I don't see why this *HAS* to be done.  This is a
>waste of time on the part of the sys admin and takes the server in
>question down for a certain ammount of time.
>
>  
>
Never said it hasto be done. Maybe I should have worded my comment as 
'for a new install, dont install MySQL at the setup stage, get the 4.0 
rpms from mysql.com and install those instead'. Does this make things 
clearer ?

Anyway, even if it was running live data already, you would still need 
to shutdown the server for the upgrade wont you ? A quick test here 
right now shows me an upgrade time of 32 seconds. That is from the time 
i haveto do a  'serverice mysqld stop' on 3.23 to when I can use the 
mysql client to log back into the new 4.0 server. But there is only 1 
small db with 40 odd megs of data in it.

Any idea what that time would be like on Oracle ?  We're prolly going 
off topic here....

-- 
Karanbir Singh <kbsingh@poboxes.com>
http://www.karan.org/ -- ICQ: 2522219