List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:May 20 2009 7:55pm
Subject:Re: Upgrade Mysql
View as plain text  
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 <paulchoi@stripped>

> 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=1
>
>

Thread
Upgrade MysqlWebmaster Studio Informatica20 May
  • Re: Upgrade MysqlScott Haneda20 May
  • Re: Upgrade MysqlDave Shariff Yadallee -  System Administrator a.k.a. The Root of the Problem20 May
  • Re: Upgrade MysqlPaul Choi20 May
    • Re: Upgrade MysqlClaudio Nanni20 May
Re: Upgrade MysqlWebmaster Studio Informatica21 May