[Khushboo]

Hi,

The query which we specify to Import, is executed on the source not on the target. So, the SQL written should be compatible with the ODBC source.

Please execute a simple query like “SELECT * from table1 LIMIT 0,5” in your source client interface i.e OpenEdge and check if it executes successfully.

It may be possible that “LIMIT” keyword is not supported by OpenEdge.

Please check which keyword(equivalent to LIMIT clause in MySQL) is supported by OpenEdge and use that in Import Wizard.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

We develop SQLyog in Visual Studio 2003 (win32) but it can be build in VS 2005 and 2008 also.

Quote:

Compiler errors SQLYog win32 (XP, visual studio 2005, Checked out revision 257)

Thank you for reporting this, we have fixed these errors and committed the code here:

https://sqlyog.googlecode.com/svn/trunk

Please update and check.

Quote:

Compiler errors SQLYog win64 (Window7, Checked out revision 257)

We have planned to migrate our project from VS 2003 to VS 2010. We will take care of all these issues, related to win64 compilation in future.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi,

We are not able to replicate your issue at our end. We checked in 8.53 and 8.4, they both have the same behavior.

Quote:

This is with SQLyog Community v8.53, worked correctly in earlier versions.

Please tell us which version you tried previously?

Thank You.

Regards,

Khushboo

[Khushboo]

Hi,

We have released 8.6 Beta1 with this feature.

“A connection tab/window can now be closed even if there is only one connection”

Please refer to:

http://www.webyog.com/blog/2010/07/20/sqlyog-mysql-gui-8-6-beta1-released/

Thanks & Regards,

Khushboo

[Khushboo]

Hi Smine,

There was a problem in our downloads page. We have fixed the issue, please download and check.

We are extremely sorry for the inconvenience.

Regards,

Khushboo

[Khushboo]

Hi Oliver,

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

“Query Formatter was not handling queries of size greater than 2 KB. Now the size is increased to 8 KB.”

Please refer to:

http://www.webyog.com/blog/2010/07/16/sqlyog-mysql-gui-8-54-released/

Thank you for reporting the issue and testing our special build.

Regards,

Khushboo

[Khushboo]

Hi Todd,

There is no way to check how many columns are there in the CSV file through Import CSV Data using LOAD LOCAL as it simply executes a data manipulation statement “LOAD DATA INFILE” to import.

For you case, you can import CSV File through Import External Data wizard. Through Import External Data –> Column Mapping Section you can check which fields you want to import from CSV and the target table. Also, in Advanced Options select “Import into existing” option. Please see the screenshots and you can also go through program's help menu.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

Issue confirmed. Horizontal Scrolling is not smooth if more number of columns (~600 rows) are present in Table Data.

We have added this in our issue tracker:

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

In order to move between successive columns you can use the “TAB” key or the left and right arrow keys or use directional arrows of the scroll bar (see the screenshot).

We will try to improve the grid scroll in our upcoming releases.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi Larry,

You can also define the color for connection while creating or connecting to that connection. This can be done through selecting a color in Advanced Tab of connection dialog. (See the screenshot)

Quote:

I figured since the tabs were color-coded that right-clicking on them would show this option.

It will be nice to have an option to change connection color in Connection Tab –> context menu. Request added in our wish list:

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

Thanks,

Khushboo

[Khushboo]

Hi Oliver,

We have fixed this issue. You can download the special (not release) binary from here.

Please try this special build in your environment and let us know the status.

Also FYI, We have scheduled all other formatter issues for our upcoming releases (post 8.5).

Thank You.

Regards,

Khushboo

[Khushboo]

Hi Oliver,

We will look into this issue with high priority and will update you once it gets fixed.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi Gary,

I have added your request in our issue tracker,

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

Right now priority is not set. We will discuss regarding this feature and prioritize accordingly.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi David,

Quote:

Error No. 2003: Can't connect to MySQL server on ((mywebsite)) (10060).

The error is described in our FAQ here, please go through this:

http://www.webyog.com/faq/content/23/15/en/error-no-2003-can_t-connect.html

It is not a problem with SQLyog. It is a networking problem.

Please tell are you able to connect using MySQL client utility?

Thank You.

Regards,

Khushboo

[Khushboo]

Hi Mike,

Please check if your table created at target has a primary key?

If the table does not have primary key, new rows will added at end but if it has then existing rows will be updated.

So in your case, table should have a primary key to update existing table.

You can send us the create table structure if the issue persist.

Thank & Regards,

Khushboo

[Khushboo]

Hi Mike,

Quote:

The MSSQL and MySQL columns are both varchar(250), when I use SQLyog to import “Subject” from cs_Posts into the “title” column of the “thread” table, it says it completes successfully but when I go into the data, the entire thread column is blank, as of nothing imported at all.

When import job completes, wizard shows how many rows are transfered, please check if it shows 0 rows transferred.

Also, please check what option you have selected in Import External Data –> Advanced Options?

(see the screenshots)

Quote:

I exported to a CSV next, then used the Import utility in SQL to bring in the CSV file to the “title” column to get my thread titles imported, but the issue I am having now, is it imports, but it appears to create new rows, not update existing.

Please use “Import into existing table” and “Update with source details” options in Import External Data –> Advanced options.

Thank You.

Regards,

Khushboo

[Author]

Posts