MySQL Bugs: #19353: mysql_upgrade program is missing

Bug #19353	mysql_upgrade program is missing
Submitted:	25 Apr 2006 20:47	Modified:	20 Jun 2006 20:55
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	5.1.9	OS:	Linux (Linux (all RPM))
Assigned to:	Kent Boortz	CPU Architecture:	Any

Description:
After installing MySQL 5.1.9 on SuSE 10.0 (using the glibc23 RPM binary packages) I experience that the mysql_upgrade program is not in /usr/bin (or anywhere else on the system). 

How to repeat:
go for it :-)

Suggested fix:
I have not researched into if the problem is that the file is not packaged or it is just not copied.  But do both ..

Thank you for a problem report. As you used RPMs, please, send the results of:

rpm -q -a | grep -i mysql

Have you downloaded and installed MySQL-client-*.rpm?

result of this: 

peter@metusalinux:~> rpm -q -a | grep -i mysql
mysql-shared-4.1.13-3
mysql-connector-odbc-3.51.12-1
MySQL-client-5.1.9-0.glibc23
php4-mysql-4.4.0-6
apache2-mod_auth_mysql-2.8.1-5
php5-mysqli-5.0.4-9
mysql-workbench-1.0.6beta-1
perl-DBD-mysql-3.0002-2
mysql-administrator-1.0.22a-2
qt3-mysql-3.3.4-28
mysql-connector-java-3.1.8-3
mysql-query-browser-1.1.12-2
MySQL-server-5.1.9-0.glibc23
rekall-mysql-2.2.1-11
postfix-mysql-2.2.5-5
php5-mysql-5.0.4-9
MySQL-shared-5.1.9-0.glibc23
peter@metusalinux:~>

The files installed were (and no errors were reported):
MySQL-server-5.1.9-0.glibc23.i386.rpm
MySQL-shared-5.1.9-0.glibc23.i386.rpm
MySQL-client-5.1.9-0.glibc23.i386.rpm

I uninstalled the previous (5.0.20a) completely using YaST GUI before installing those, but I see now that there is an old mysql-shared-4.1.13-3 (probably because it was the one that came with the distribution and was not aware of this one when I replaced with 5.0.18.  Can that be the problem?

Looks like it is really missing:

openxs@suse:~/dbs/5.0> rpm -q --filesbypkg -p /tmp/MySQL-server-5.1.9-0.glibc23.i386.rpm | grep upgrade
warning: /tmp/MySQL-server-5.1.9-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
openxs@suse:~/dbs/5.0> rpm -q --filesbypkg -p /tmp/MySQL-client-5.1.9-0.glibc23.i386.rpm | grep upgrade
warning: /tmp/MySQL-client-5.1.9-0.glibc23.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
openxs@suse:~/dbs/5.0>

Same issue with the MySQL 5.0.20a glibc23 RPM package!

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/5688

The 5.1 version of bug#18516.
Please see there for all further info.