ID #1016

Why are Stored Procedures not created when I import an SQL-file?

 

This is a privilege issue.

You will probably get the error 1044 "Access denied ..." or 1370 "Alter routine command denied to user ...". Data are imported OK, Views too, but Stored Procedures and Functions are not.

The reason is that the user does not have the CREATE ROUTINE or ALTER ROUTINE privileges as of MySQL 5.x. On some MySQL version those privileges are not available as global privileges (except for 'root'@'localhost'). This has been reported as a bug with early MySQL 5.0 versions.

With SQLyog User management you can give the user the privileges.

Please also read this FAQ

 

Tags: -

Related entries:

Last update: 2006-07-07 19:35
Author: Peter Laursen
Revision: 1.1

{writeDiggMsgTag} {writeFacebookMsgTag} {writePrintMsgTag} {writeSend2FriendMsgTag} {writePDFTag}
{translationForm}
Rate this FAQ

Average rating: 4 (4 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ