MySQL Embedded dumping empty procedures

[a.alekizoglou]

I am using UniDAC 5.1.4 with MySQL Embedded server 5.6.14

If I run

Code: Select all

SHOW CREATE PROCEDURE someproc

the resultset has every field filled in except the Create Function, where the SQL statement for creating the procedure is.

I've open the same DB with dbForge and run show create procedure again, and everything is filled in correctly. The same stand for functions as they rely on the same logic.

[AndreyZ]

The "SHOW CREATE PROCEDURE" and "SHOW CREATE FUNCTION" statements require you to be the owner of the routine or have SELECT access to the mysql.proc table. If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function field will be NULL. You can find the information about this at http://dev.mysql.com/doc/refman/5.6/en/ ... edure.html
Please make sure that you are using the same user name and password in both dbForge Studio for MySQL and UniDAC. If you did not enable credentials usage for your MySQL embedded, make sure that the user name and password are blank.

[a.alekizoglou]

Thanks Andrey,

That was the problem. I've read that yesterday and saw that the embedded DB was created with blank username/password, and I was using a non-blank username/password for UniDump.

BTW, I've altered UniDump to include procedures and triggers for dumping MySQL DB. Is there a specific reason you have not write this in the component?

[AndreyZ]

For the time being, TUniDump does not support dumping procedures and triggers. We have such request at our UserVoice page at http://devart.uservoice.com/forums/1046 ... at-it-can- . You can vote for it there. Suggestions with many votes will be implemented faster.