[peterlaursen]

Please answer:

1) Operation System? XP, Vista?

2) Did you try to reboot the OS?

3) Is there a DUMP file in the installation folder?

[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

[peterlaursen]

Yes if you open in an editor that does not support uft8, saving the file will garble the content.

Before SQLyog 6 the files were ANSI-encoded, from version 6 they are utf8 encoded!

[peterlaursen]

addtional:

Connections are pooled on the server on the basis of: client IP, user name, password. so if there are five connections for say 192.168.16, root, rootpwd, mysql_pconnect can return any one of them. This is important when comparing with phpMyadmin, becuase phpMyAdmin has its own (mysql)user that is always used.

Refer to http://php.net/function.mysql-pconnect

If persistent is ON and if phpMyAdmin can use it the SQLyog/HTTP tunnelling can too. But don't create more than one persistent connection for every combination of client IP and user name!

[peterlaursen]

We had an almost similar report 20 hours ago! We are testing the fix for this now!

I think the problem the “comment inside conditional comment” conctruction inside the CREATE PROCEDURE statement like

/*!50003 …

….

— a comment

…

*/

Coul you please try to remove '– a comment' and verify if that solves the issue?

[peterlaursen]

If phpmyadmin can use persistent connection I do not see any reason why SQLyog should not!

I will ask the developer who maintains the tunneller file to help with this tomorrow!

[peterlaursen]

1) In what program do you open/view the file? Windows version? SQLyog 6 uses utf8 encoding for such files. If the program where you open it does not support utf8 accented characters will display as sequences of two characters. Using utf8 is the only way to ensure portability across platforms and LOCALES. Also the 'mysqldump' program does the same.

You may attach a sample DUMP file here (please zip it!) and we will study the file!

2) try this:

– export a table

– rename the original table

– import to the original table name

isn't it OK after import?

[peterlaursen]

Can you tell if php_mysql() or php_mysqli() extension is available/used? There is no mysqli_pconnect().

If php_mysql is used, Is 'Allow_persistent = ON´ in php configuration ([mysqld] section of php.ini)? But even if it is it is not always sufficient. I have experienced on some servers that it is not and I think that also webserver configuration has influence. But I do not know details.

What is the phpMyAdmin version and can you attach phpMyAdmin configuration file here?

Also the returns of phpinfo() could be useful! I am a little surprised that phpMyAdmin seems to have no problem and would like to find out how it does!

[peterlaursen]

Actually there is a little bit silly consequence of what we are doing now!

If you have a database without a single table, but lot of ROUTINES, you cannot export anything at all. The program forces you to 'select at least one table'.

[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]

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]

Yes, we have similar requests. I think we will implement in the 6.1 tree.

[peterlaursen]

Are you using HTTP tunnel? If so is PHP version the same? Was SQLyog/the tunneler upgraded recently?

User variables only live as long as the connection. With HTTP tunnel a new connection is created for every statement (unless persistent connection is ON in PHP configuration and supported by webserver configuration)

So when you execute “SELECT @N := @N +1” @N is NULL and NULL + 1 = NULL

As it works with phpMyAdmin it seems that pesrsistent connection is supported on the host. You can edit the tunneller file and replace mysql_connect() with mysql_pconnect.

This is the only reason I can see. If that is not the issue, I think we need more details

[peterlaursen]

“I am talking about opening the file I double click on, not pasting the statement”

Now what I figured was that if you choose to associate .sql files with SQLyog and doubleclick such file, the SQLyog will open and the content of the file will be displayed in the editor. It SQLyog is allready open then the new file would open in a new tab in the currently selected connection. Do we agree?

The only problem is that no connection is open if the program is not open (and then no Query Tab is open either), but of course we can 'push in between' a connections dialogue.

[peterlaursen]

very strange indeed! Ctrl+2 works perfectly for me! and we have no other report of such issue.

You are sure you don't Ctrl+F2 instead?

Also the divider has not been moved to lowest postion?

If your are totally 'locked' then you can try renaming the sqlyog.ini file before starting SQLyog. A new one will be created from scratch then

[Author]

Posts