From: Tauren Mills
Date: March 26 1999 9:43am
Subject: RE: Length of Database name field inconsistent
List-Archive: http://lists.mysql.com/mysql/1005
Message-Id: <000b01be776d$2438dec0$1ad7a2d1@easystreet.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I just tried to upgraded my to 3.22.20 on my RedHat 5.2 linux installation
from 3.22.13.  Here is what happened:

[root@s1 packages]# rpm -Uvh MySQL-3.22.20a-1.i386.rpm
/usr/bin/mysqlbug conflicts with file from MySQL-client-3.22.13-beta-1
error: MySQL-3.22.20a-1.i386.rpm cannot be installed
[root@s1 packages]# rpm -Uvh MySQL-client-3.22.20a-1.i386.rpm
/usr/bin/mysqlbug conflicts with file from MySQL-3.22.13-beta-1
error: MySQL-client-3.22.20a-1.i386.rpm cannot be installed

So I did this:

[root@s1 packages]# rpm -Uvhi --replacefiles
MySQL-client-3.22.20a-1.i386.rpm
[root@s1 packages]# rpm -Uvh MySQL-3.22.20a-1.i386.rpm

And things seemed to install properly.

BUT...  The mysql database itself didn't get changed.  The database name
field is still 32 characters, not 64.  Do I need to uninstall MySQL and then
reinstall it to really upgrade?  If so, what is the easiest way to preserve
the users/hosts/databases in the mysql tables?  Should I just alter the
tables manually?  Or are there other field definitions that have changed
too?

Thanks,
Tauren


> -----Original Message-----
> From: Michael Widenius [mailto:monty@stripped]
> Sent: Sunday, March 21, 1999 9:03 AM
> To: Tauren Mills
> Cc: Paul DuBois
> Subject: RE: Length of Database name field inconsistent
>
>
> >>>>> "Tauren" == Tauren Mills <tauren@stripped> writes:
>
> Tauren> Hmmm.  Looks like I need to upgrade this server.  I've
> got 3.22.14-gamma
> Tauren> running on my Solaris box, but I haven't upgraded this
> Linux box yet.  Here
> Tauren> is the version info:
>
> <cut>
>
> Yes, an upgrade will extend the database name from 32 to 64
> characters!
>
> Regards,
> Monty
>