[sathish]

Hello,

 

We have added this request in our issue tracker here: https://code.google.com/p/sqlyog/issues/detail?id=2033  Currently we do not have free resource to work on this. We will discuss this and take it up based on priority assigned to it.

 

Regards,

Sathish

[sathish]

Hello,

 

I can extract a sample database if you wish me to send you a sample demonstrating the problem.

 

 

It would be helpful if could provide us the sample data.

 

Regards,

Sathish

[sathish]

Hello,

 

List of tables is displayed but any other operations give the “tunneling error” (after a minute of hanging).

 

 

Could you please elaborate a little on this. it would be helpful if you could tell us what are the operations that you referring to.

 

Regards,

Sathish

[sathish]

Hello,

 

We are unable to reproduce this issue. Could you please provide us a sample dump where this is reproducible and also the jobfile so that we can check this.

Also please tell:

1) Exact SQLyog version(Help->About)?

2) The connection type(Direct/HTTP/SSH)?

 

Regards,

Sathish

[sathish]

The first discussion we had about this is here: http://forums.webyog.com/index.php?showtopic=7114 and we have added your request here: https://code.google.com/p/sqlyog/issues/detail?id=1932 

[sathish]

Hello,

 

Could you please create a private support ticket by sending a mail to [email protected] 

 

Regards,

Sathish

[sathish]

Hello,

 

It would be helpful if could provide the create table structure of the table where you are importing and also a sample csv file where this issue is reproducible. 

And please attach a screenshot of the options that you are using while importing.

 

Regards,

Sathish

 

[sathish]

Hello,

 

Could you please tell us how exactly you are getting this error?

The exact SQLyog version(Help->About)?

The MySQL server version involved( Select version(); ) 

 

Regards,

Sathish

[sathish]

Hello,

 

You can change the AUTO_INCREMENT value from SQLyog. You can find this option in Advanced tab in Create/Alter table. Please find the screen shot attached.

 

Also quoting about AUTO_INCREMENT from MySQL docs:

 

 

You cannot reset the counter to a value less than or equal to any that have already been used. For MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum plus one. For InnoDB, if the value is less than the current maximum value in the column, no error occurs and the current sequence value is not changed.

 

Please refer: http://dev.mysql.com/doc/refman/5.5/en/alter-table.html

 

Regards,

Sathish

 

 

[sathish]

Hello,

 

We have already replied in the support ticket create by you.

 

Regards,

Sathish

[sathish]

Hello,

 

We have already replied in the ticket created by you. Let us continue in the support ticket. 

 

Regards,

Sathish

[sathish]

Hello,

 

This issue is fixed in the current development tree. And the fix will be available in the next public release. 

 

Regards,

Sathish

[sathish]

Hello,

 

Issue reproducible. We are checking this. Thanks for reporting.

 

Regards,

Sathish

[sathish]

Hello,

 

Could you please tell us what is the exact version of SQLyog that you are using(Help->About)?

 

How many rows you are trying to load at a time? If you are trying to load million rows at a time then you can use ‘paginated display’. It is not designed for display of millions of rows at the same time.” Please see the screen-shot attached.

 

Please note that 32 bit process can at max access 3 GB of RAM. This means that even though you have 8GB RAM, if the size of the result set is > 3GB (and in some cases 2G:cool:, then SQLyog cannot display them.

 

Regards,

Sathish

[sathish]

The link had two extra spaces at the end. Here is the correct one: https://code.google.com/p/sqlyog/issues/detail?id=1709

[Author]

Posts