[navyashree.r]

debbie wrote on Aug 28 2008, 12:20 PM:

Thanks… guess I don't need to stay on the 'edit' of the servers very long, once I'm configured I'm good.

Although, for me it would be more useful that a stick it would go back to edit to the same area. Like 'Data collection' option, and then when I would need to go to edit the server, I would be right there in data collection to turn on/off the collect data option.

Hi,

Your request is added in our list. Thank you.

Regards,

Navya

[navyashree.r]

Hi,

This issue is not related to our SQLyog MySQL gui. But i make an attempt to answer for your query.

In earlier versions of Microsoft Office, you could set your preferences for specific view, display, and editing settings in the Options dialog box (Tools menu, Options command). Now in 2007 Microsoft Office system programs: Word, Excel, PowerPoint, and Access, the Options command on the Tools menu has been moved so that it is under Word Options, Excel Options, PowerPoint Options, or Access Options after you click the Microsoft Office Button .

To find the program settings that control things such as your preferences to correct spelling or save a file, click Word Options, Excel Options, PowerPoint Options, or Access Options after you click the Microsoft Office Button .

For more info please go through Microsoft Access Help doc.

Regards,

Navya

[navyashree.r]

Hi Taras,

Thank you for suggestion. Your request has been added in our list,

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

Regards,

Navya

[navyashree.r]

bichonfrise74 wrote on Aug 22 2008, 11:53 PM:

/* Alter table in Second database */

alter table `t2`.`testme` COMMENT='';

If I use SQLyog 6.55 in Windows, it will give the correct result which is:

/* Alter table in Second database */

alter table `t2`.`testme`

add column `missing_id` bigint(20) NULL after `id`,

change `zipcode` `zipcode` varchar(255) NULL after `missing_id`, COMMENT='';

Hi,

Thank you for your testcase. We reproduced at our end. We will look into the issue.

Regards,

Navya

[navyashree.r]

Hi,

Your request is already in our list. Thank you for suggestions.

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

Regards,

Navya

[navyashree.r]

Taras Tielkes wrote on Aug 24 2008, 10:55 AM:

I know it's in the plans to make more dialogs resizable.

Just wanted to add my vote for making the dialog “Manage Privileges” resizable.

Hi,

Thank you for your interest.

Regards,

Navya

[navyashree.r]

gnodeb wrote on Aug 14 2008, 11:35 AM:

I really like SSH tunneling, but I'm forced to use HTTP tunneling because SSH is allowed only through proxy (security reasons as usual :).

We already have proxy support for HTTP tunneling, so I hope that we can see the same option for SSH…

Hi,

Thank you for your interest. We will discuss.

Regards,

Navya

[navyashree.r]

Taras Tielkes wrote on Aug 15 2008, 06:52 AM:

Looking at the status bar, the last query I executed took 8321921 milliseconds.

I would be nice if the execution time would be displayed in a format that's actually easy to parse by humans.

Something like 3:01:37.757 (hours:minutes:seconds.milliseconds).

Hi,

Your request is already in our list,

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

Regards,

Navya

[navyashree.r]

Hi,

Quote:

Where is the .ini file?

I read somewhere on this forum where it was stored but that was for v6 and I cant seem to find it in the program folder

Starting from version 6.06 the sqlyog.ini file is moved to a new position.

The old file in the installation folder was renamed with a .bak extension

You will need to copy and rename the file manually. The new position is

Windows 2000/XP/2003:

documents and settings{user}application datasqlyog

Windows Vista:

users{user}AppDataroamingSQLyog

(some folders may have a localized name on non-English Windows)

Regards,

Navya

[navyashree.r]

Hi,

tfg wrote on Aug 14 2008, 01:42 AM:

1) Can you use SQLyog to compare two tables? I am only interested in if they are exactly the same or not. Would be even better if you had a graphical method to view the differences.

SQLyog MySQL GUI is the most powerful tool which can be used to compare two tables. So, this could be done by using 2 most powerful features.

* If you want to compare only the structure then we can use Schema Synchronization tool where we can compare 2 databases and see the differences which object (tables, store procedures, views, triggers, functions and events) is identical, altered, which should be created or which should be deleted from target. All these are displayed in different colors to have more graphical and user friendly.

After comparing queries will be displayed in Query tab in Schema Sync tool. You can select which object should be executed in target. So, press Execute button.

* If you want to compare the data of table, then we can use Data Synchronization tool. Here, we can do one way or two way sync for Source and Target. To see, only the difference then we can generate only script.

tfg wrote on Aug 14 2008, 01:42 AM:

2) I did a backup of a database as an SQL dump (under tools). It created a single (big) file. I see that you can restore from a dump file but am wondering about what if you want only some of the information in the file? Must this be done by hand?

I am not much clear with this question but what i understood — If you select a database with all Objects checked and dumped, you restore whole database.

Instead you can select a database and in tree-view select which objects (tables, store procedures, views, triggers, functions and events) is required and uncheck which is not required. This can be done using Schedule backup or Backup Database as SQL dump file tools. In this case you can see info of selected object.

Here information means you can select whole object but not the few rows in table. For more info please refer SQLyog Help document.

Regards,

Navya

[navyashree.r]

strato wrote on Aug 7 2008, 11:17 PM:

I am new to the program. In phpmyadmin I can easily search table XXX field ZZZ containing data CCCC or anything I want. I haven't been able to find that feature in sqlyog. Can you help me? Is there such a feature to search for data in the tables?

Hi Strato,

Regarding 'Search table' option. Thos request is already in our list,

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

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

strato wrote on Aug 7 2008, 11:17 PM:

Another question. How do I run a sql query?

To execute a query follow the steps below,

1. Type a query in Query Editor for example,

Select * from tablename1;

2. Ways to execute a query.

— Right click context menu. Then select 'Execute Query'

— Keyboard shortcut F9 for single query, Ctrl + F9 for selected query, Shift +F9 for all queries and F8 for executeand edit resultset.

— Go to Edit menu –> Execute query

— In toolbar, press on Green button to execute query/queries.

For more information please see our help document regarding executing a query.

Regards,

Navya

[navyashree.r]

chilm wrote on Aug 7 2008, 12:42 PM:

Thnx for the swift reply's, great product will never ever go without it. 😀

Hi Chilm,

Thanks for your interest. With pleasure 🙂

Regards,

Navya

[navyashree.r]

Hi,

Your request has been added to our list,

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

Thank you.

Regards,

Navya

[navyashree.r]

rvps wrote on Aug 1 2008, 05:14 PM:

This is the first time I've had to use the PHPTunneling. (Client is a very beauricratic straight phpMyAdmin shop gasp! and will not open up any ssh tunnels)

I've got to say. WHAT AN AWESOME FEATURE!!!

Big Kudos on this one. For what everyone said about speed, I've found that it actually runs faster than directly connected. Go figure.

Thanks!

Thank you for your great words. 🙂

Regards,

Navya

[navyashree.r]

Hi Dave,'

This is SQLyog issue. So, please post in the right category. I am moving this issue to 'SQLyog Bugs and Feature' section.

Regards,

Navya

[Author]

Posts