Bug 146739

Summary:	MySQL misses tables after update
Product:	[openSUSE] SUSE Linux 10.1	Reporter:	Christian Boltz <suse-beta>
Component:	Update Problems	Assignee:	Michal Marek <mmarek>
Status:	VERIFIED FIXED	QA Contact:	Klaus Kämpf <kkaempf>
Severity:	Normal
Priority:	P5 - None
Version:	Beta 2
Target Milestone:	---
Hardware:	Other
OS:	Other
Whiteboard:
Found By:	Other	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---
Attachments:	rcmysql

Description Christian Boltz 2006-01-30 18:42:12 UTC

I installed 10.1 beta2 as update to 10.0 final.

MySQL basically works, but the tables for stored procedures etc. are missing:

mysql> create procedure keep_summary [...]
ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

I guess this problem does not appear on new installations because MySQL creates fresh tables when database "mysql" does not (yet) exist.

On updates, the "mysql" database already exists, but is incomplete.

-> the required tables for stored procedures, functions, views and triggers
   should be created when updating to MySQL 5.x

Comment 1 Michal Marek 2006-01-31 17:26:09 UTC

Hi,

thanks for the report. I've modified the rcmysql script to run
mysql_fix_privilege_tables when updating from 4.1 to 5.0. I'll attach the
script so that you can test it. The updated mysql package will appear in
opensuse factory soon.

Comment 2 Michal Marek 2006-01-31 17:27:48 UTC

Created attachment 65901 [details]
rcmysql

This is the updated init script.

Comment 3 Christian Boltz 2006-02-02 23:30:40 UTC

Works perfectly - test succeed :-)

Thanks!

Comment 4 Lenz Grimmer 2006-03-16 14:08:21 UTC

Excellent, thanks a lot for taking care of this! Please note that we have implemented a slightly different solution for this, starting with MySQL 5.0.19 - see http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html for details. It should not be too difficult to support your scheme and making the transition to the new update mechanism we now implemented.