forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Block Comments /*….*/ Don't Work In 'restore From Sql Dump&#
- This topic is empty.
-
AuthorPosts
-
-
August 16, 2007 at 8:35 am #24684
peterlaursen
ParticipantThe 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!
-
August 16, 2007 at 8:44 am #24685
peterlaursen
Participantthe 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!
-
August 17, 2007 at 12:57 pm #24686
peterlaursen
ParticipantPlease 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
-
August 19, 2007 at 11:13 pm #24687
Simeon
Member😀
peterlaursen wrote on Aug 18 2007, 12:57 AM:Please verify the fix for this withEnterprise (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!
-
-
AuthorPosts
- You must be logged in to reply to this topic.