[Ritesh]

Quote:

where do I have to create the log directory???

Create c:mysqliblogs

[Ritesh]

The .inf seems OK.

You need to create the iblogs directory manually and give the information in my.inf

[Ritesh]

Quote:

One observation/ feature request that would improve productivity considerably (at least for me) would be retention of the selected tab (Result, Messages, Objects, History) upon double-click of the table in the left tree view. Currently the double click always brings the user to the 'Objects' tab. I would like to select a tab and then be able to cycle through a few of the tables by double-clicking

Quote:

Another request. Instead of having to hit f8 for an edit window, can a tab be added to accomplish the same thing. This way (combined with the first request) I can make updates and enter data quickly throughout the DB without so many keystrokes and clicks.

Both the above features are in our TO-DO list. We are currently working on GUI and proabably will completely change the UI in one of the future releases.

[Ritesh]

Quote:

import from Access97 [win98 myODBC ] to mySQL

This is happening because the ODBC driver for Access returns SQLyog the information.

You can change a COLUMN datatype, by clicking on the Transform BUTTON in Select Table(s) box of the ODBC Import Wizard tool.

[Ritesh]

Quote:

TeamID (should also be a foreign key)

Quote:

WorkshopID (SHOULD BE the foreign key)

The above two fields dont have indexes defined on them? For foreign keys to be defined on columns, those columns should have indexes defined on it.

For more information you can check out the InnoDB docs at InnoDB Homepage

[Ritesh]

Quote:

Can I synchronize 2 databases on 2 differents servers with SQLyog ?

Yes. You can 😀

Just connect to different servers. Select Tools->Database Synchronization Tool… and in the Combo dropdown you will find databases of both the servers ( i.e. connections ).

Select the databases you want to synchronize and choose one of the output option.

[Ritesh]

Quote:

I am using InnoDB tables!!!! So where is the problem?!

Check out the columns which you are using in the relationship have proper indexes created on them.

It would be very helpful if you can tell me the structure of the two tables and the steps you are following to create the index.

[Ritesh]

Quote:

Will be added on a future release ?

Yes 🙂

[Ritesh]

Quote:

When do you plan to release 3.1 version?

Within ONE week. Would you like to test SQLyog 3.1 before we officially release it?

[Ritesh]

Quote:

Why not SQL Yog have this feature built in ?

SQLyog will support such big files in one of the future upgrades.

[Ritesh]

Quote:

and in 3.03 is 5000. Try not to do this on a dial-up connection

Once you change the limit and press DONE… the LIMITS are automatically stored for next session 🙂

[Ritesh]

You can copy the whole database with its table structures/data between two hosts. Just connect to two hosts as you are doing and choose a DATABASE in the object browser and select Copy Database… from the popup menu ( as show in screenshot 1 ).

You will get a dialog ( as shown in screenshot 2 ).

As of now you cannot select indivisual tables to be copied between two hosts but we plan to implement in our next release i.e. SQLyog 3.1

Screenshot 1:

Screenshot 2:

[Ritesh]

Quote:

Also: Some way of scheduling queries would be greatly appreciated!

This feature is one the item in TO-DO list.

[Ritesh]

You have to connect to both the hosts ( source and target ) using the connection dialog…SQLyog lists all databases for all connections.

After you have connected to the first host select File->Connect… to connect to a different host

[Ritesh]

You will find File Attachments… option ( just below the Post Icon ). Use the option to upload your image.

[Author]

Posts