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:

You can comment this FAQ