Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (128706 views)
- Error no. 2003: Can't connect... (58524 views)
- Error no. 1251: "Client does not support authentication..." (50543 views)
- Error no. 1045: "Connection denied..." (46251 views)
- SQLyog Version History (45078 views)
- Error No. 2005: Unknown MySQL server host... (33381 views)
- What is HTTP-tunneling? (32472 views)
- What Is SSH and SSH-tunneling? (28003 views)
- Why are Stored Procedures not created when I import ... (27058 views)
- Do I need PHP to use SQLyog with MySQL? ... (23937 views)
Latest FAQs
- SQLyog Version History (2010-09-02 04:20)
- Do I need to replace the PHP tunneler file ... (2010-03-25 10:26)
- Data get truncated when importing a large CSV-file. (2010-03-18 12:30)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
Working with Views, Stored Procedures and Triggers
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:
- Do I need PHP to use SQLyog with MySQL?
- Welcome to the Webyog FAQ
- Installation and upgrading
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
Last update: 2006-07-07 19:35
Author: Peter Laursen
Revision: 1.1
You can comment this FAQ