MySQL Forums
Forum List  »  General

Re: Stored procedure problem on upgrade to 5.0.1
Posted by: Harrison Fisk
Date: November 22, 2004 11:21AM

Hi,

Most likely the issue is that stored procedures now are assigned to a database in 5.0.1, whereas in 5.0.0 they were all global. If you manually change the 'db' column in the mysql.proc table, then you should be able to see the procedures in the database now.

Hope that helps.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Written By
Posted
Re: Stored procedure problem on upgrade to 5.0.1
November 22, 2004 11:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.