[Mahesh]

You should enable “Notify when stable” option in Notification settings to get recovery email.

(Please see the attached screen shot)

[Mahesh]

This has happened because of latest changes in Customer Area for Beta/RC section,

Sorry for the inconvenience.

You can now download and start using SQLyog v8.5 RC2.

[Mahesh]

Please try using

./Downloads/MONyog/bin/MONyog start instead ./Downloads/MONyog/bin/MONyog-bin start

OR

Goto bin folder and execute ./MONyog start

[Mahesh]

We tried similar case at our end but not reproducible:

Steps followed:

1) Entered Single server key

2) Register one server

3) Again Tried to Register another server,

Error “..Please upgrade your MONyog License..”

4) Now entered Two server license key

5) Register second server successfully

6) Both server Immediately shown in “List of servers” page.

7) After Service restart also shows both the server

Please tell Operating system where MONyog is running?

[Mahesh]

Com_create_table

The Com_create_table counter variables indicate the number of times each CREATE TABLE statement has been executed.

So, in your case MONyog shows expected result as 31379 as these many time CREATE TABLE statement has been executed on server irrespective of Table engine types(InnoDB, MyISAM etc..)

mysql> SHOW GLOBAL STATUS LIKE 'Com_create_table';

+

---

+

---

+

| Variable_name | Value |

+

---

+

---

+

| Com_create_table | 31379 |

[Mahesh]

Are you sure that extension of the file is .schemaxml

Can you please attach a .schemaxml file here ?

[Mahesh]

This issue has been fixed in latest v8.32.

http://www.webyog.com/en/downloads.php

Regards,

Mahesh

[Mahesh]

Issue Confirmed

We will analyze this and get back to you soon.

Thanks for your Co-Operation.

[Mahesh]

Can you please attach a structure only dump of all tables along with problematic query(If differs from previous).You can use “Backup database as SQLdump”.

We have created an account for you to send files here, https://www.yousendit.com/login.php

Please login with the below details,

Email : [email protected]

Password : tester

and send file(zipped) to email address “[email protected]” mentioning subject as “SQLyog Buffer Overrun”.

We will check this behavior at our end and get back to you.

[Mahesh]

We are now releasing 8.4 RC including a very significant auto-complete speed improvement.

Please refer to:

http://www.webyog.com/blog/2010/04/20/sqlyog-mysql-gui-8-4-rc-has-been-released/

Please provide your feedback to that one.

[Mahesh]

We have this request already added here http://code.google.com/p/sqlyog/issues/detail?id=308

[Mahesh]

Please download latest version v8.32 GA from here and try again.

http://code.google.com/p/sqlyog/downloads/list

[Mahesh]

We are executing:

“SHOW CREATE PROCEDURE `dbname.spname”;

Resultset return by server does not show comments in this case.

Can you please provide the details like which MySQL client has this settings(MySQL command-line tool/MySQL QB/MySQL workbench) ?

Thanks,

Mahesh

[Mahesh]

This is MySQL question instead SQLyog.

Length()function Returns the length of the string str, measured in bytes. A multi-byte character counts as multiple bytes. This means that for a string containing five two-byte characters, LENGTH() returns 10, whereas CHAR_LENGTH() returns 5.

http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_length

In your case :

select length('123ä');

Output:

5

but for

select CHAR_LENGTH('123ä');

Output:

4

Because “ä” is a multibyte character.

[Mahesh]

Using Schema sync tool you can compare two schema and make them sync by executing queries there itself on click of “Execute All” button.

There is no need to copy and paste SQL statements to editor and execute.

Please tell,

1) Are you getting this error “No database selected” every time OR only in particular case?

2) Exact source and target MySQL server version?

3) Are you using direct/Http/SSH method ?

4) We need a reproducible test case for both source and target schema?(You can use “Backup database as SQL dump.” tool to backup source and target database)

[Author]

Posts