Block Comments /*….*/ Don't Work In 'restore From Sql Dump&#

[peterlaursen]

The error is confirmed on MySQL 5.0.45

Could you explain “Currently they don't work because the Asterisk, forward slash combination

is used as a delimiter in the restore proces” ??

Now as we can execute this from the editor we also should when executing an external script. I think it might be an issue with 'multiline' comments.

We will have to find out now!

[peterlaursen]

the issue is that the SP itself is enclosed in 'version dependent conditional comments' in the DUMP file like

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `testSP`()

BEGIN

/* comment */

SELECT 'Hello' greeting;

END */

And this we do not handle correctly in case of external file execution!

This will be fixed of course!

[peterlaursen]

Please verify the fix for this with

Enterprise (registered): http://www.webyog.com/downloads/betas/not_…QLyog606Ent.exe

Enterprise (trial): : http://www.webyog.com/downloads/betas/not_…606EntTrial.exe

Community: http://www.webyog.com/downloads/betas/not_…d/SQLyog606.exe

[Simeon]

😀

peterlaursen wrote on Aug 18 2007, 12:57 AM:

Please verify the fix for this with

Enterprise (registered): http://www.webyog.com/downloads/betas/not_…QLyog606Ent.exe

Enterprise (trial): http://www.webyog.com/downloads/betas/not_…606EntTrial.exe

Community: http://www.webyog.com/downloads/betas/not_…d/SQLyog606.exe

Yes, this has fixed the problem outlined here, and also the issue raised in “Restore From Sql Dump 'glitch' For Stored Procedure”

Thanks for your prompt fix – this has already made life much easier!

[Author]

Posts