What type of installation is your corrent MySQL config ?? (i.e. RPM, source,
etc)
I find that the best way to manage updates, and be able to 'save' different
versions for 'fallback' or testing, is to always use the 'source'
distribution (not the source RPM).
I 'config' the package with the --prefix=/usr/local/mysql directive which puts
ALL of the MySQL stuff in that directory 'tree'.
When 'upgrading', I shutdown MySQL, 'move' the current "mysql" directory
aside (i.e. mv mysql mysql-3.23.22) and build and install the new version
(after performing the 'make install' command, I 'tar' the old "var" directory
to the new "mysql" directory 'tree') and restart MySQL. You shouldn't have
any DB compatibility problems, since the old and new versions are both in the
3.23 family...
August Simonelli wrote:
> Hi all,
>
> I have recently set up a linux box with red hat 7.1. i installed mysql
> and php and apache and have a really cool development area that works
> nicely. i am running mysql 3.23.32 and would like to upgrade it ... on
> the mysql site it has patches and full server rpm's ... what should i be
> doing to upgrade? do i download a patch with the newest version or do a
> complete install of the latest server rpm? i've read the section in the
> manual and it helps me with the actual install but not this patch vs
> full rpm idea ...
>
> sorry if i missed something really obvious ... i am off to tinker with
> it but any help would be great!
>
> thanks,
>
> august simonelli
>
