[Khushboo]

Hello,

We have released SQLyog 8.31Beta1 with this feature.

“Dumps created with ’scheduled backup’ can now be zipped.”

Please refer to:

http://www.webyog.com/blog/2010/03/19/sqlyog-mysql-gui-8-31-beta1-has-been-released/

Thanks & Regards,

Khushboo

[Khushboo]

Hello,

We have released SQLyog 8.31Beta1 with this feature.

“Dumps created with ’scheduled backup’ can now be zipped.”

Please refer to:

http://www.webyog.com/blog/2010/03/19/sqlyog-mysql-gui-8-31-beta1-has-been-released/

Thanks & Regards,

Khushboo

[Khushboo]

Hello,

We have released SQLyog 8.31Beta1 with this multiple monitor fix.

Refer to:

http://www.webyog.com/blog/2010/03/19/sqlyog-mysql-gui-8-31-beta1-has-been-released/

Please evaluate and let us know the status.

Thanks & Regards,

Khushboo

[Khushboo]

Hi Martin,

Thank you for your patience.

Please try this once.

1. Use your old ini.

2. Start SQLyog and Open all the options of Tools –> Show one by one and simply press escape(It will close the dialog, so no need to kill the application)

3. Check does the above mentioned three sections are created in ini?

If yes then paste the values here.

Then as a work around you can set those values to 0 like:

Left=0

Top=0

Right=0

Bottom=0

and check if it solves your issue.

Thanks & Regards,

Khushboo

[Khushboo]

Hi Martin,

Thank you for your valuable response.

We need some more information about this. Please send the values for the below sections of ini:

[ShowVariable]

Left=

Top=

Right=

Bottom=

[ShowProcessList]

Left=

Top=

Right=

Bottom=

[ShowStatus]

Left=

Top=

Right=

Bottom=

We are analyzing your issue, in the mean while you can delete these sections from your ini and try again.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

Please tell us, have you ever used more than one monitor previously.

Please tell whether this workaround solves the issue

– Close SQLyog

– Please search for the section name : “ShowValues” in SQLyog ini and delete that section.

– Start SQLyog and check again.

Path for SQLyog ini:

Windows 2K/XP/2003:

C:Documents and Settings{user}Application DataSQLyog

Windows Vista/2008/7:

C:Users{user}AppDataRoamingSQLyog

We suspect that the issue might be related to the multi monitor fix which we made in 8.3.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

Currently SQLyog does not support this feature.

You need to use Import External Data to import rows from table in Excel.

But we already have similar feature requests in our issue tracker:

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

We will discuss regarding this and prioritize accordingly.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi,

Thanks for the information.

We will set up a similar environment and check the issue.

We will update the status once done.

Regards,

Khushboo

[Khushboo]

Hi Angleet,

1. Please tell us your system configuration(Linux version, Wine version etc), you can paste the output of these commands:

a. uname -a

b. cat /etc/issue

c. wine –version

2. Please tell us the type of DSN you created (System, file or user).

Quote:

I'm using the trial version of 2.2.

Is it SQLyog 8.2 ? Please tell the correct SQLyog version.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

I think you got confused, the Trigger Option in Import External Data is for “Updating Source Table” not the “Target Table”.

Quote:

Not quite – what i actually would need is to be able to update another row – NOT the source row

This is not possible through Import External Data, for this you need manually to create a trigger in MySQL server and specify the trigger event for your case.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

We added the feature request “Common Destination Table for all files” in our issue tracker:

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

We will discuss this and prioritize accordingly.

Thanks & Regards,

Khushboo

[Khushboo]

Hello,

Till now what we understood is that you want to add a custom Where clause to update the source row.

Currently this is not possible with SQLyog, but this will be a nice feature to include.

We can add an option in Import External Data –> Advanced Tab –> Trigger Option, where user can define a 'custom where clause' which will affect the source row.

Please correct us, if there is still any misunderstanding from our side.

Thanks & Regards,

Khushboo

[Khushboo]

Hello,

Currently SQLyog is supporting “incremental import” using TRIGGER functionality in Import External Data.

To understand this better, please read this FAQ:

http://webyog.com/faq/content/17/79/en/can-i-perform-incremental-import-with-the-sqlyog-import-external-data-tool.html

To run a custom SQL, you can use “SQL Where” option present in Import External Data (see the screen shots).

Thank You.

Regards,

Khushboo

[Khushboo]

Hi Smine,

Quote:

1. i cannot find “don't overwrite” option

You can find an option in Import External Data –> Advanced Option –> Keep Target Data, if you check this then on duplicate data, Import will generate INSERT statements to add data into existing table, means it will not overwrite any data.(see the screen-shot)

Quote:

2. when i click “Select All” to select all tables, the Destination is automatically filled with a table name based on the CSV filename. i change it for one table then click “Apply changes to all tables” but the Destination does not change. do i have to manually change every Destination table name?

Yes, you need to manually change every Destination table name.

Right now Import External Data doesn't have any option to select a “Common Destination Table” for all files. But its a valid feature request and we will discuss about this.

Quote:

3. if i do set the Destination of each file, the import appears to work for the first table, but other tables fail with these errors (slightly edited)

ERROR: 1054, Unknown column 'F1' in 'field list'

The error occurs because there is difference between the fields of table created by 1st .CSV file and the fields which are present 2nd .CSV file.

1. Please use “Keep Target Data option” instead of “Update with Source Details” option.

2. You can check the Import External Data –> Column Mapping section to see the difference in the fields of .CSV files.(see the screen shot)

3. Please try to import two or three files in different tables and provide us with the table structures of the created tables. This will help us to get the exact problem which you are facing.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi,

Its not a bug in SQLyog.

We tried with a test case:

CREATE TABLE t1 (

a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

message CHAR(20)) ENGINE=MyISAM;

CREATE TABLE t2 (

a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

message CHAR(20)) ENGINE=MyISAM;

INSERT INTO t1 (message) VALUES ('Testing'),('table'),('t1');

INSERT INTO t2 (message) VALUES ('Testing'),('table'),('t2');

CREATE TABLE table_merge (

a INT NOT NULL AUTO_INCREMENT,

message CHAR(20), INDEX(a))

ENGINE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;

SELECT * FROM table_merge;

And tried to edit from result tab, it worked fine at our end.

So, can you please check the following cases:

1. Check that “You must have SELECT, DELETE, and UPDATE privileges on the MyISAM tables that you map to a MERGE table”.

2. Check your create table syntax, as there are some limitations for merge tables documented here:

http://dev.mysql.com/doc/refman/5.0/en/merge-table-problems.html

3. Are you able to perform edit and save in table data tab?

Thanks & Regards,

Khushboo

[Author]

Posts