repo to use for mysql 5.0 upgrade

[jludwig]

On Monday 06 March 2006 19:01, Ted Potter wrote:
> Greetings all,
>
> FC4 using yum I would like to upgrade mysql (server and client) to the
> latest version (5.0)
>
> Does anyone know which repo I can use ? (freshrpm did not seem to have
> anything)
>
> Thanks for any tips !
>
>
>
> --
> Ted Potter
> tpotter at techmarin.com
I did this earlier and replied to the fedora list.

This is what I sent;
--> Be forwarned this could be dangerous and should be checked on a
--> non-production machine.  Reboot to be sure that MySQL starts properly!!

> I have been watching the MySQL5 dialog with interest and finally decided to
> install 5.0 myself.
>
> My process;
> 1) Download and install the source rpm.
>
> 2) Change to the usr/src/redhat/SPECS directory
>
> 3) Run rpmbuild
>     --> rpmbuild -bb mysql-5.0.18.spec ( and wait forever).
>
> 4) Back up all databases. 
( and configuration files!! )
>
> 5) Install the rpms
>    --> rpm -Uvh --nodeps --force MySQL-*.i386.rpm
>
> 6) Run  mysql_fix_privilege_tables --password=XXXXXXX
>    --> mysql_fix_privilege_tables --password=XXXXXXX
>
> 7) Check all ok except mysql-admin (mysqladmin ok though)
>
> [root at localhost SPECS]# mysqladmin status -p
> Enter password:
> Uptime: 1468  Threads: 1  Questions: 267  Slow queries: 0  Opens: 0  Flush
> tables: 1  Open tables: 10  Queries per second avg: 0.182
>
> [root at localhost SPECS]# mysqladmin version -p
> Enter password:
> mysqladmin  Ver 8.41 Distrib 5.0.18, for pc-linux-gnu on i686
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version          5.0.18-max
> Protocol version        10
> Connection              Localhost via UNIX socket
> UNIX socket             /var/lib/mysql/mysql.sock
> Uptime:                 25 min 58 sec