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 ... (128704 views)
- Error no. 2003: Can't connect... (58523 views)
- Error no. 1251: "Client does not support authentication..." (50541 views)
- Error no. 1045: "Connection denied..." (46251 views)
- SQLyog Version History (45077 views)
- Error No. 2005: Unknown MySQL server host... (33381 views)
- What is HTTP-tunneling? (32471 views)
- What Is SSH and SSH-tunneling? (28002 views)
- Why are Stored Procedures not created when I import ... (27057 views)
- Do I need PHP to use SQLyog with MySQL? ... (23936 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
MySQL 5 objects are greyed out in "copy DB to other host" dialogue.
MySQL version 5 objects (Views, Stored Procedures and Functions) are greyed out in "copy DB to other host" dialogue and the objects are not created with the database copied to.
That happens when the names of the two databases involved are different. It is due to the fact that MySQL returns the SP, Function, Trigger and View definition with database name in it. Thus it looks like:
create procedure db_name.xxxxxx ( .... )
It is very difficult and time-consuming coding to correctly strip out the database name and execute it in a different context automatically. Further we have been informed that the format of what is returned will change with a future MySQL version 5 releases. We have decided then not to spend time with it at this point time. When MySQL comes up with their final solution we will adjust accordingly.
Until then database names must be identical to copy MySQL version 5 objects.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- Welcome to the Webyog FAQ
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
Last update: 2005-09-21 04:45
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ