From: Martijn Tonies
Date: December 1 2006 11:02am
Subject: Re: unable to create function in MySQL 5.0
List-Archive: http://lists.mysql.com/mysql/203665
Message-Id: <015a01c71538$34b2e680$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello Ted,

> I got an error that I don't understand:
> 
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or
> \g.
> Your MySQL connection id is 3080 to server version:
> 5.0.18-log
> 
> mysql> create function do_system returns integer
> soname 'raptor_udf.so'//
> ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

Is this an upgrade from a v4/v4.1 version?

If so, make sure to run the upgrade script for the "mysql"
database.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com