[ashwin]

Hi edziffel,

This is a bug with Ubuntu 10.04 and not with SQLyog. The workaround is described here: http://www.webyog.com/faq/content/31/184/en/i-am-unable-to-run-sqlyog-in-wine_ubuntu-104-what-should-i-do.html . There is no such problem on Ubuntu before and after 10.04.

Thanks,

Ashwin A

[ashwin]

Quote:

Is access to it also available in right click context menus and database menu?

Yes. Data search is available in connection/database/table/column right click context menu.

[ashwin]

Hi arkid77,

Quote:

A simple request that would make a powerful feature. Simply when right clicking on an entire database or going to the database menu, for there to be a search option. This would then let you search for a string from any field of any table in the given database.

We already have this feature- 'Data Search'. This feature lets you find specific data without actually writing any SQL. We implemented 'Data Search' in SQLyog v9.10 and enhanced in v9.20. Refer v9.20 release Blog: http://www.webyog.com/blog/2011/07/25/data-search-enhanced-in-sqlyog-9-2/

Thanks,

Ashwin A

[ashwin]

Hi Smine,

Thanks for bringing this to our notice. We had planned but not implemented. It has been added in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1684

We will discuss and prioritize accordingly.

Thanks,

Ashwin A

[ashwin]

@jtarbox,

Are you connected to MySQL server through a VPN connection?

[ashwin]

Hi Mitch,

We are unable to reproduce this issue. Can you attach screenshots of manage indexes and INFO tab? Also please tell your MySQL server version(Execute SELECT VERSION())

Thanks,

Ashwin A

[ashwin]

Hi Efolia,

Quote:

1) The ability to jump to the first/last row of a table in a paged display (the double arrows in PHPMyAdmin). This is an important feature to have quick access to when you're testing actual data because you usually want to validate the last value that was entered.

We already have feature request to add “|<" and ">|” buttons (go to first/go to last) in addition to “<" and ">“(go to first/previous). It is added here: http://code.google.com/p/sqlyog/issues/detail?id=1604

Currently the priority is not set, but we will discuss and prioritize accordingly.

Quote:

2) The ability to upload and download backups in an archived format (at least gzip).

You can use 'Scheduled backup'(Powertools->Scheduled backup) to backup in zip format. But we do not have an option to decompress from inside SQLyog. There is similar request in our issue tracker: http://code.google.com/p/sqlyog/issues/detail?id=1306

We will discuss about this and prioritize.

Thanks,

Ashwin A

[ashwin]

Hi Jason,

We will fix the filter reset bug in the next public release.

And, We have decided to move data tab, info tab, history tab to the query tab level as they are not dependent on the query tab. This has been added here: http://code.google.com/p/sqlyog/issues/detail?id=1682

We will inform you once we this has been implemented.

Thanks,

Ashwin A

[ashwin]

Hi Jason O'neil,

Common Table For Each 'query' Tab is not a bug actually, it is by design. Whichever table you choose in the Object browser you will be viewing the same in the table data across different query tabs. But there is a request to make data tab 'sticky'. Refer: http://code.google.com/p/sqlyog/issues/detail?id=1574

Quote:

It also produces a bug – if we set some filter in 1st tab on step 2), after 4) and switching to 'Table Data' we have error – filter in 1st tab from tabA is applied to tabB.

This is a bug. Filter should be reset after you switch back to the query tab1. I have added this issue in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1681

[ashwin]

Hi Knudsen,

The table mapping feature request is already there in our issue tracker: http://code.google.com/p/sqlyog/issues/detail?id=1608

Currently we do not have an option to do table mapping for different table names with the same schema. Data Sync creates a new table in the target which you want to sync if same table name is not present.

Thanks,

Ashwin A

[ashwin]

Hi Huang,

Quote:

Now, when I create a new row, the automatically generated 'id' is 10000. But I want the automatically generated 'id' is 9800, rather than 10000,

You can set the 'id' as 9800 by executing query:

ALTER TABLE tbl AUTO_INCREMENT = 9800;

But if there is a row already present in the table with 'id' 9800 then you cannot create with the same 'id' as it becomes 'duplicate row'.

Quote:

Can I disable this “Auto-increment”?

Right-click on the table->Alter Table(F6)->Disable “Auto Incr?” (Refer attached image)

[ashwin]

Hi,

Quote:

I couldn't keep the rows in the order of the 'id' number I entered. Whenever I refresh the table, then the rows changed their order.

The row ordering is done by the server not by SQLyog. This is because the “Auto-increment” is enabled on the column('id' in your case). So MySQL assigns sequence numbers automatically.

Quote:

But I couldn't find a way to set up the 'id' number I want SQLyog to generate.

To start with an AUTO_INCREMENT value other than 1, you can set that value with CREATE TABLE or ALTER TABLE, like this:

ALTER TABLE tbl AUTO_INCREMENT = 100;

Refer: http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html

Thanks,

Ashwin A

[ashwin]

Hi,

We already have similar feature requests in our issue tracker and I have added your request there:

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

Currently the priority is not set, but we will discuss and prioritize accordingly.

Thanks,

Ashwin A

[ashwin]

Hi,

The Schema Designer is designed not to keep track of the table name changes and hence throws a message “Unable to load table(s)”. I have added this in our issue tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1669

We will schedule this according to our priority.

Thanks,

Ashwin A

[ashwin]

Hi,

SQLyog's Import External Data requires access to the system tables of the Microsoft Access database for the purpose of reverse-engineering. By default, read access to the system tables of an Access database is restricted for external applications. The procedure to enable the read access depends on the MS-Office/Access version. But in every case you must first un-hide the system tables and next change some of their properties. This procedure is explained here: http://www.webyog.com/en/whitepapers/Preparing_Access__Migration.pdf

Please follow the steps as mentioned in the above Preparing_Access__Migration.pdf file and you will be able to import properly.

Thanks and Regards,

Ashwin A

[Author]

Posts