[ashwin]

Hi,

We have released SQLyog 8.8 beta1 with this fix, which is available publicly!

Please refer to:

http://www.webyog.com/blog/2011/01/04/sqlyog-mysql-gui-8-8-beta-1-released/

Thank you for reporting the issue.

Regards,

Ashwin

[ashwin]

Please execute these queries in SQLyog editor:

SELECT `ENGINE`, `SUPPORT` FROM information_schema.Engines;

And

SHOW ENGINES;

and paste your results here.

Also can you tell us your MySQL and SQLyog version you are using.

[ashwin]

Hi,

Can you execute “SHOW ENGINES” and check what Storage Engines are available for your server. Because SQLyog queries ('asks') the server about what types/engines are available and only displays the ones available (that may vary considerably depending on the server version, the platform where the server runs and how it was compiled and how it is configured).

Read this FAQ to know more about what Storage Engines are supported by SQLyog:

http://www.webyog.com/faq/content/29/135/en/what-storage-engines-are-supported-by-sqlyog.html

[ashwin]

Hi Linda,

Quote:

Either don't include quotes around numeric values as the default or include an option in the export dialog box.

We already have an option “Optionally” in the Export as CSV -> Change -> Specify the Escape Characters(See the attached image). If you select “Optionally” only the string values will be quoted not the numeric values.

[ashwin]

Hi,

Issue confirmed. Issue added here: http://code.google.com/p/sqlyog/issues/detail?id=1579

Thanks for reporting.

[ashwin]

Issue is confirmed. Issue added in our issue tracker:

http://code.google.com/p/sqlyog/issues/detail?id=1578

[ashwin]

Hi Joseph,

Quote:

The table is about 300 MB in size after being exported to a txt file from the source db

Which optino should I select? (In the export Data as Batch Script Wizard)

Generate bulk INSERT statement

Generate complete INSERT statement

Generate INSERT DELAYED statement

You can use the “Generate Bulk INSERT statement” option. When this option is checked data from more rows will be written into a single INSERT statement. Each INSERT statement will be allowed to grow to the size specified in the 'Max. size of BULK INSERTS' setting.

And to know about the settings that should be taken into consideration when specifying BULKS, you can refer the FAQ link:

http://www.webyog.com/faq/content/24/101/en/about-chunks-and-bulks.html

[ashwin]

Hi,

Issue confirmed. Issue added here: http://code.google.com/p/sqlyog/issues/detail?id=1567

Thank you for reporting.

[ashwin]

Hi,

Can you tell the exact SQLyog version you are using?

[ashwin]

Hi,

Quote:

it'd be very useful to have a feature (a simple TAB pressure near the * char) that lets you to expand SELECT * and SELECT table.* statements so that they list all of the columns that exist in the referenced tables.

Please tell the exact case from the two listed below:

1. Do you want a shortcut key to replace * with all the columns in the table?

2. Do you want to list all the columns belonging to a particular table in a popup window?

If it is the second one, then we have the autocomplete feature available in PROFESSIONAL/ENTERPRISE/ULIMATE editions of SQLyog. Please go through the program help file to know more.

[ashwin]

Quote:

What is the rule on how Sqlyog shows table rows by the GUI alone (not using SELECT statements)?

The rule is that- For the first time when table is exposed the limit rows will be checked and the limit value is 0-100. Since then it will keep the persistence what user is setting himself.

Please tell, Whether this issue is reproducible to you?

[ashwin]

Hello,

Quote:

If I just change those two database names to, say, taskplus_restored, would that be sufficient?

Yes its enough, this will work as you expected.

Quote:

I just tried to restore a test db, but it failed, with error code 1064. I don't understand why it would fail, after just dumping it using MySQLyog!

No idea about this, We need to know which query is failed, error 1064 is syntax error.

The query and error is logged into:

Windows XP/2003:

C:Application Data{user}SQLyogsqlyog.err

Windows Vista/7:

C:Users{user}AppDataRoamingSQLyogsqlyog.err

First delete the above file, Do restore from SQLdump, check the error file(sqlyog.err)created, and you can see which query is failed.

[ashwin]

Hi,

I added your request to our Issue Tracker : http://code.google.com/p/sqlyog/issues/detail?id=1501

[ashwin]

Hello,

I have added your request here :

http://code.google.com/p/sqlyog/issues/detail?id=1473

Thanks for your suggestion.

[Author]

Posts