[Khushboo]

Hi,

We have fixed this issue and the fix will be included in next release.

If you are in urgent need of the fix now, we can provide you a special build.

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

Issue confirmed and added in our tracker,

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

We have started looking into this issue and will update here the status

Thank You for reporting.

Regards,

Khushboo

[Khushboo]

Hi Sommerjack,

Can you tell us more details:

1. What's your OS?.

If it is Windows Vista/7, then can you please reboot the OS.

It could be an issue with Windows Vista/7 'Data Execution Prevention (DEP)' feature that is not quite stable. A reboot will normally solve this. Please reboot and let us know the status.

2.This crash started when you install/uninstall some application?

3.Check if any installed security related program 'knocks down' SQLyog. Most security suites come with some 'script killer' feature.

4.Could you please attach the dump, so that we can try at our end?

Also, it is public holiday in India today, so only tomorrow we will be able to look into this.

Thank You.

Regards,

Khushboo

[Khushboo]

Hi Daniel,

Thanks for the suggestion.

The requested feature is already under consideration.

code.google.com/p/sqlyog/issues/detail?id=727

We will definitely improve the filter options.

We will discuss about this feature implementation with other team members and update.

Thank you.

Regards,

Khushboo

[Khushboo]

Hi Rick,

Yes, it is possible to change ini file location in SQLyog.

From 8.13 we have this feature,

“SQLyog can be started with a ‘-dir’ switch like “SQLyogENT -dir some folder”. This -dir switch specifies where SQLyog will look for the sqlyog.ini file and where all writable files will be saved. This was mainly implemented for users that want to have all SQLyog-related files on a removable drive or some kind of encrypted storage. Note that if you use the setting in ‘preferences’ to store TAGS file some specific place the ‘preferences’ setting will still have effect, also if the -dir switch is used.”

Thank You.

Regards,

Khushboo

[Khushboo]

Hi,

We checked the dump, it is pointing towards windows file.

1. Can you please reboot the OS?

It could be an issue with Windows Vista/7 'Data Execution Prevention (DEP)' feature that is not quite stable. A reboot will normally solve this. Please reboot and let us know the status.

2.Check if any installed security related program 'knocks down' SQLyog. Most security suites come with some 'script killer' feature.

Thanks & Regards,

Khushboo

[Khushboo]

Hi Jim,

“Colored interface based on connection”, we have prioritize this feature in 8.3 Beta and you can expect this to be available by next week. Now for every connection you can choose different colors for object browser and the color for that connection will be saved in SQLyog.ini file.

Thanks & Regards,

Khushboo

[Khushboo]

Hi Uyuni,

This issue is fixed and available in SQLyog 8.21 RC, released!

The option to display ‘all’ versus a ‘LIMIT’ed set of rows in DATA tab is now table-specific and saved across sessions.

Please refer to:

http://www.webyog.com/blog/2010/01/05/sqlyog-mysql-gui-8-21-rc-has-been-released/

Please let us know the status.

Thank you.

Regards,

Khushboo

[Khushboo]

Hi Joebruin,

Thank you for your interest in SQLyog.

This feature request is already listed in our issue tracker,

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

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

Regards,

Khushboo

[Khushboo]

Hi Sunco,

SQLyog.ini file stores all the connection settings. It is present in 'AppData' folder.

Exact file file path is:

For Windows 2K/XP/2003:

C:documents and settingsuserapplication dataSQLyogsqlyog.ini

For Windows Vista/2008/Win7:

C:UsersuserAppDataRoamingSQLyogsqlyog.ini

Please note that the 'AppData' folder is a hidden folder. You need to unhide it from Control Panel .. folder options.

You need to copy/backup this SQLyog.ini file and paste in AppData folder (same path) of the system where you are going to install new SQLyog.

Regards,

Khushboo

[Khushboo]

Hi Bkelley,

There are two tools through which you can import CSV Files in SQLyog:

1)Import External Data

i) Go to Powertools –> “Import External Data”

ii)Select Type of Source as “CSV” give CSV folder path

“is there a limit on the “Import External Data” function file size?”

No, there is no limit on file size in Import External Data. You can import large files in GB.

2)Import CSV data using LOAD LOCAL

Select a Table –> Right Click –> Import CSV using LOAD LOCAL … “

Here also you can import large CSV files.

You can use any of these two tools to import large CSV Files to a table.

Please See the screenshots and read these FAQs:

http://webyog.com/faq/content/17/110/en/i-have-a-large-%23-of-csv-files-can-sqlyog-import-them-all-in-one-operation.html

http://webyog.com/faq/content/28/73/en/i-have-problems-with-importing-csv-data.html

Regards,

Khushboo

[Khushboo]

Hi,

Currently, queries using FORCE INDEX, USE INDEX and IGNORE INDEX are not supported by SQLyog Formatter.

We will improve this once we plan for an enhancement. Right now priority is not set.

We added your request in the issue tracker,

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

BTW

FYI other formatting issues are listed here and all will be considered later while enhancing this feature,

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

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

Thanks & Regards,

Khushboo

[Khushboo]

Hi,

This fix is available publicly in SQLyog 8.21 Beta1.

Please refer to:

http://www.webyog.com/blog/2009/12/18/sqlyog-mysql-gui-8-21-beta-1-has-been-released/

Thank you.

Regards,

Khushboo

[Khushboo]

Hi,

This fix is available publicly in SQLyog 8.21 Beta1.

Please refer to:

http://www.webyog.com/blog/2009/12/18/sqlyog-mysql-gui-8-21-beta-1-has-been-released/

Thank you.

Regards,

Khushboo

[Khushboo]

Hi Ganesh,

SQLyog has never encountered any such problems.

Anyways, we tried your case and it is not reproducible at our end.

If you have manually deleted some records through SQLyog and data is saved, then those records will be deleted from the server.

Can you please try you case with latest version of SQLyog 8.2 ?

If you still have same problems, then please elaborate your test case and provide us sample table structure for which problem occurred.

Thanks You.

Regards,

Khushboo

[Author]

Posts