upgrade mysql

Hi all,
I'm running MySQL 3.22.32 and need to upgrade it to the 3.23.51.

Mysql is running on the Cobalt RaQ4 system.
can anyone tell me where can I find some solid information about

upgrading mysql, or if you guys know how to do that, please help me out.

I don't want to do a clean installation of newer mysql as I have few
databases running on the current version mysql. I'm pretty new to this
stuff. anykind of help will be really appriciated. Thanks so much

rahad




------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Upgrade Mysql

--000e0cd2559406abaa046a5d6a6b
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I already posted about this:

http://lists.mysql.com/mysql/215100

or google for "moving from 3.23.58 to 5.0.45"


I never recommend to install mysql as default package, is way too limiting.
I manage to have as many mysql installations on the same server as the
hardware can carry,
but not software conflict.
Always install mysql in custom way:
http://lists.mysql.com/mysql/211957


Cheers

Claudio


2009/5/20 Paul Choi

> Hi,
>
> I don't know what Linux distro you're using, but I'd make a backup of
> /var/lib/mysql dir before you do anything (in case the mysql package decides
> to nuke your stuff). If you have a dump of your dbs, that's fine too. And
> maybe a backup of your my.cnf.
>
> Just install the new mysql package, then start it. Then you'll need to run
> "mysqlupgrade". Depending on the size of your database and type of tables
> you are using it can take a while. For InnoDB tables, for example, upgrade
> simply means copy to tmp table... that's really slow if you have a large
> table.
>
> Once mysqlupgrade runs without a hitch, you should be back in business.
>
> -Paul
>
>
>
> Webmaster Studio Informatica wrote:
>
>> Hi,
>>
>>
>> I need to upgrade Mysql 4 to Mysql 5 on Linux.
>>
>>
>> I will uninstall version 4 and install version 5.
>>
>>
>>
>> With uninstallation usually database files remain in /var/lib/mysql/
>>
>>
>>
>>
>> I want to know if with the installation of Mysql 5 those database will be
>> "recognized and imported" to work with the new version automatically.
>>
>>
>>
>>
>> Thank You.
>>
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>
>

--000e0cd2559406abaa046a5d6a6b--

Re: Upgrade Mysql

------=_NextPart_000_0007_01C9DA45.8E8EC690
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thank You for all the help.

I was upgrading from 4.0.x to 5.0.x

The new mysql recognized the old databases without problems.

Bye :)
------=_NextPart_000_0007_01C9DA45.8E8EC690--