[jjscott]

Wow. I totally missed that. Apologies for the confusion and thanks for setting me straight!

[jjscott]

I don't think you understand what I'm trying to do. I'm not trying to execute one sql statement at a time. I'm trying to execute multiple statements in a script. It would appear that you ran each statement individually and took screenshots after each statement was run. Try using the “Execute All Queries” for the following script. I bet it doesn't proceed past the “SELECT SLEEP(@TimeInterval);” statement.

In order to get the desired result provided by the end of the script, I had to highlight everything after the “SELECT SLEEP(@TimeInterval);” statement and run “Execute All Queries”. I had to do this after the script terminated at the “SELECT SLEEP(@TimeInterval);”. As mentioned in my original post, I don't have to do this if I run the same script from the MySQL command line. Is this normal behavior for SQLYog?

SET @TimeInterval = 10;

SELECT variable_value INTO @num1 FROM information_schema.global_status

WHERE variable_name = 'Innodb_os_log_written';

SELECT SLEEP(@TimeInterval);

SELECT variable_value INTO @num2 FROM information_schema.global_status

WHERE variable_name = 'Innodb_os_log_written';

SET @ByteWrittenToLog = @num2 – @num1;

SET @KB_WL_HR = @ByteWrittenToLog / POWER(1024,1) * 3600 / @TimeInterval;

SET @MB_WL_HR = @ByteWrittenToLog / POWER(1024,2) * 3600 / @TimeInterval;

SET @GB_WL_HR = @ByteWrittenToLog / POWER(1024,3) * 3600 / @TimeInterval;

SELECT @KB_WL_HR,@MB_WL_HR,@GB_WL_HR;

[jjscott]

Thanks. I installed it and took a quick look. On the surface, everything looks fine. The password for the sync & backup is encrypted.

[jjscott]

'sathish' wrote:

Hello,

We have added this request in our issue tracker here: https://code.google.com/p/sqlyog/issues/detail?id=1551 We will schedule this according to priority.

Regards,

Sathish

I noticed the issue you attached my request to has been open since 2010. Do you have a ballpark date as to when this will be completed?

[jjscott]

'peterlaursen' wrote:

we are strugggling with an issue in a new feature (http://code.google.com/p/sqlyog/issues/detail?id=827) that we need to solve before we can release 9.1 beta. It is somewhat unpredictable if it will take 3 hours or 3 days. So the best I can say now is: end of this week or beginning of next.

Will this change also encrypt the username & password for the backup xml file?

How is your team coming with the changes?

[jjscott]

Any word on the status of version 11.1? I checked the download site and only see v11.0.1.

Thanks

[jjscott]

Excellent

[jjscott]

That's great ti hear, Jan. I really like the product and would hate to have to move on because of this. Can you share the expected release date for v11.1?

By the way, I just downloaded the trail version of MONYog. I look forward to playing with it.

[jjscott]

I’ve recently started using SQLYog (v10.3) for database synchronization and noticed the same security flaw as reported by others. Are there any plans to address this? I noticed this thread is over three years old. Corporate auditors tend to frown on plain text passwords.

[Author]

Posts