[Ritesh]

Yes. SQLyog is definitely the tool for you 😀

Just connect to your remote MySQL server ( provided your ISP has provided you with enough permission ). Use DB->Export Database As Batch Script…

You can try SQLyog's Database Synchronization Tool. It can be accessed from Tools->Database Synchronization Tool. You can even schedule it to regularly synchronize your remote database with your local one.

[Ritesh]

Quote:

1/ Allow users to sort tables (asc/desc) by clicking on the field names, like it's done in the view data window

2/ Allow to dynamically search either the entire table or a column (field). I'd create radio buttons above each field allowing me to select the field I wanna search through (or the leftmost column radio button to select entire table) and then update the view with each letter typed.

– For example if I had a user database with fields 'userid' 'nickname' 'email' and Id select the nickname field to search, then hit the 'p' key, only the rows containing nicknames starting with 'p' would still be displayed. “*p*” would display all nicks containing p… 'punt' would probably only still show my nickname ('puntloos') etc.

3/ Remember changes users WANT to make in this editor, and commit the changes when pressing the 'Done' button and NOT commit them if I hit 'Cancel'. I feel extremely uncomfortable editing a live table with your tool, knowing that one typo, wrong key could irrevokably damage my table.

4/ Allow me to resize the display window

All the features except “2” are planned for SQLyog Max.

[Ritesh]

Copy sqlyog.ini from your SQLyog directory to the SQLyog directory of your new box 🙂

HTH

[Ritesh]

SQLyog only supports synchronization between 2 MySQL databases 🙁

[Ritesh]

From the SQLyog Documentation:

Quote:

To execute the whole batch of queries that you have entered in the SQL window, press Shift+F5. This will result in execution of all queries one by one, with multiple tab window for each resultset.

HTH

[Ritesh]

kengaun wrote on Dec 17 2003, 08:40 AM:

Hi,

Any update regarding the error message : Could not read the data for the table!

when I tried to click alter table structure ?

MySQL has changed the structure of result returned by “show table status…” in MySQL 4.1.1.

We will be coming out with 3.64 RC2 by the end of this month. It will have all the bugs related to 4.1.1 fixed 😀

[Ritesh]

Quote:

Error No. 1130

Host 'IP-Adress' is not allowed to connect to this MySQL server

MySQL uses HOST based authentication. Check out http://www.mysql.com/doc/en/Privileges.html for more information.

Quote:

Error No. 2003

Can't connect to MySQL Server on 'IP-Adress'(10061)

This means that there is no MySQL server running on 'IP-Address'.

HTH

[Ritesh]

SQLyog 3.64 RC1 has been released. Check out http://www.webyog.com/forums/index.php?act…&st=0#entry1942

This version uses the new libmysql.dll for connecting to MySQL 4.1.1.

[Ritesh]

SQLyog 3.64 RC1 has been released. Check out http://www.webyog.com/forums/index.php?act…&st=0#entry1942

This version uses the new libmysql.dll for connecting to MySQL 4.1.1.

[Ritesh]

Take a look at http://www.webyog.com/forums/index.php?act…ct=ST&f=5&t=658

[Ritesh]

Excerpts from the MySQL Reference Manual

Code:

6.5.3.1 Silent Column Specification Changes

If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLO:cool:, all CHAR columns longer than three characters are changed to VARCHAR columns. This doesn't affect how you use the columns in any way; in MySQL, VARCHAR is just a different way to store characters. MySQL performs this conversion because it saves space and makes table operations faster.

[Ritesh]

Can you explain a little more?

[Ritesh]

SQLyog Max going to be released in mid-2004 will be available for Linux.

As of now SJA is only available as a cross-platform solution.

[Ritesh]

SJA runs in a different thread that you can terminate in between 😀

ODBC Import is executed in the same thread as the application. This is why we get a “NOT RESPONDING” message in the task bar.

SQLyog Max is being built as a multithreaded application from ground up. All these problems will be fixed in Max 😀

[Ritesh]

This is what MySQL AB has to say:

Quote:

The above situation can be caused by two issues only. One is

 malfunctioning in SSL protocol and the other one is incompatibility in

 password scrambling algorithms.

 

 As our Windows version does not have SSL, you have hit a problem in

 password scrambling.

 

 MySQL 4.1 has introduced a new password scheme, which utilizes much

 longer and much more secure passwords then version 4.0.

 

 If client library from version 4.0 is trying to authenticate a user

 with a new, long password, then it will fail, with a “Bad handshake”

 error.

We will release SQLyog 3.64, as soon as we get an updated version of libmysql.dll from MySQL AB. This is going to be as early as next week

[Author]

Posts