[jack111]

Quote:

We plan to add this to the GRIDs:

* add select all/deselect all functionality

* add 'SHIFT+click modifiers' (like in the gmail webinterface)

* add an option to select a row without using the mouse (SPACEBAR has been proposed for that. Idea is that it should be possible to scroll through a table or a resultset with arrow keys and select rows without using the mouse.

We have a few issues and enhancements with the Query Builder and the Schema Designer that will be handled first (and I guess that will take 3-4 weeks) – and the above issues are next task assigned for this particular developer.

I wonder what is happening to adding the above functionality. Been close to 4 months now.

[jack111]

Fantastic.

Thank you very much

[jack111]

peterlaursen wrote on May 11 2007, 03:20 PM:

“Error Code: 2006 – MySQL server has gone away”

I think the most likely reason is that the (server) max_allowed_packet setting is too low compared to the size of BULK inserts in the file.

Old server versions dispaly only that in this situation. 5.0.41 say “got a package too big” or something like that!

Thanks that was exactly the problem. Followed the instructions below

http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

In Linux:

Copy the my-xxx.cnf file from /usr/share/mysql to /etc as my.cnf

xxx can be small, medium, large, huge … depending on the requirement.

$ cp /usr/share/mysql/my-xxx.cnf /etc/my.cnf

In the my.cnf file, change the default

max_allowed_packet = 1M

to

max_allowed_packet = 16M

Save the file and restart MySQL server.

In Windows:

In the MySQL server installation directory,

in my.ini file, add the following line under [mysqld] in SERVER SECTION.

max_allowed_packet = 16M

Save the file and restart MySQL server.

[jack111]

Quote:

It looks like Symantec released new detections this morning!

With the latest detections there is no alert!

anybody can confirm this?

The security alert no longer shows up now

[jack111]

Quote:

You do not need to be horrified, but better be informative!!!

What do you mean “better be informative” I donot like the tone of your statement. First for somebody who is trying to help a thank you would be a good start.

As regards being informative ……………… I have clearly stated that it is norton internet security 2007 and given you the date I updated it. Read it again below if you missed it the first time.

Quote:

I tend to keep my software updated and today [26 march 2007 ] when I when to the download area and tried to download the latest update to my shock found that a trogan was being downloaded. luckily norton internet security 2007 fixed it for me.

When did that happen and when did it not happen and what has changed in between? …………………. I saw a valid security concern and reported it. When did people start shooting the messenger.

[jack111]

The server is a dedicated server with a 100mbps connection to a internet backbone.

My broadband connection is 10mbps download and 384Kbps upload.

connect using tunelling via SSH when using sqlyog.

do you know where I set it so that i can allow a faster upload

I think it might be a configuring OPENSSH to allow faster uploads

thanks

[jack111]

Hi

thanks for the reply.

have tried with both bulk and single row inserts does not make much of a difference. Though with single insers the file size is much bigger thus will take longer.

issue is the slow speed taken to execute sql scripts.

While I can take any sql file of size say 4mb and execute it via webmin via uploading on my mysql database in less than 10 minutes max usually takes about 5 minutes. With sqlyog or navicat it takes about 2 hours.

donot understand what is going on

[jack111]

Executed the same sql script with webmin via the upload option in less the 4 minutes.

If I had used SQLYOG it woud have taken 2 hours. This seems to apply for navicat as well.

Anybody any ideas

[jack111]

peterlaursen wrote on Oct 23 2006, 03:01 PM:

we do have plans for some kind of 'easy selection of multiple rows'.

We have not actually planned this right/click selection feature, but and CTRL and SPACE 'click modifiers'.

My personal idea is something like the gmail interface for multiple selection, but every detail is not planned.

The gmail interface I think is what you already have in sqlyog. Or very similar.

I donot like the idea of using a tick box to select a querry every time.

Newer experimental websites coming out wherein you just scroll and as you go over a particular area either a dropdown menu is selected etc with out needing to click. But I would be most happy with what mysqlcc allows you to do probably what I have got used to.

[jack111]

Quote:

?????? When did you arrive? I think I remember it was yesterday! I remember quite a lot of users 'sticking around' for some years.

looks like this has been hard on you have a rest or something. Are you here to scare off prospective clients !!!. You sure are doing a good job of it.

Now to the testing part of it. I connect to my freebsd server remotely via the ssh tunnels and used a 333kb script to fill in a new database. Below are the results.

SQLyog SQL SCRIPT TAKEN FROM phpmyadmin and executed on TEST database [the SQL SCRIPT WAS 333KB in size]

13:58:15 [start time]

14:08:30 [Finish time]

execute querys: 10148

time taken=10 minutes 15 seconds

NAVICAT SQL SCRIPT TAKEN FROM phpmyadmin for TEST database [exactly same script used]

14:12:20 [start time]

14:22:45 [Finish time]

10 minutes 25 seconds

time = 623.734s

execute querrys: 5075

Both navicat and SQLyog take the same time. Infact SQLyog is about 15 seconds quicker.

The only thing is SQLyog states it has executed 10148 querries which is wrong as there were only 5075 querries in the script. I really donot care about that though.

I also did the same again on LOCALHOST ie on my computer mysql set up. Both navicat and SQLyog executed the same script in under 10 seconds. So my initial assessement of navicat being quicker was WRONG.

SQLyog is something you need to spend a bit of time with [couple of days would be plenty] to understand the interface. Before anybody come in shouting this is “A PERSONAL OPINION”

Now that I have got used to the SQLyog interface the more I use it the better it gets.

SO NOT GOING TO ASK FOR MY REFUND AFTER ALL

[jack111]

TomBez wrote on Sep 7 2006, 10:15 AM:

from the performance point of view it's pretty much the same.

I'm a user not sqlyog-guy

Nice to hear from a none sqlyog-guy atleast get some unbiased reviews.

My comments are pasted as I carry on testing both NAVICAT and SQLyog. I just put on this forum what I my experiences are. And it is as things happen in fact you can take this as a live blog.

For peterlaursen to give me the solutions here is a bit too late as most users donot stick around as long as me. Infact I almost cancelled my order and was goint to buy navicat. But thought I would stick around a bit longer. I am glad I did.

The more I use SQLyog the more I like it. But at the moment NAVICAT is still in the lead as it was a painfree induction………….everything was easy………..did not have to think………..had a natural flow to it.

SQLyog is difficult to understand. I have been using mysqlcc and phpmyadmin now for 2 years so If I am finding SQLyog difficult than you certainly can do a lot to better to improve the flow of things.

You can either listen to your customers and make changes or lose out.

YOU NEED TO MAKE THE SQLyog interaction more user friendly

I will give my thoughts as I carry on the testing process and hope you implement them in your next update

[jack111]

Another update as I continue to test both NAVICAT and SQLyog.

SQL BACKUP SCRIPTS

with SQLyog the back file leave details in a horizontal format

Code:

insert into `ip_logs` (`mid`,`time`,`ip`) values (19,1155332255,'ipaddress'),(2,1155332132,'ipaddress'),(2,1155299488,'ipaddress'),(2,1155299179,'ipaddress'),(2,1155299008,'ipaddress'),(2,1155298729,'ipaddress'),(2,1155291550,'ipaddress'),(2,1157217939,'ipaddress'),(2,1157195026,'ipaddress'),(2,1157185904,'ipaddress'),(20,1155333083,'ipaddress'),(2,1155333161,'ipaddress'),(2,1155333250,'ipaddress'),(21,1155333545,'ipaddress'),(22,1155373636,'ipaddress'),(22,1155383692,'ipaddress'),

This is just a short data strip image even it was a lot of data you would be going side ways for ever.

Navicat does in nicely in an easy to view format

Code:

INSERT INTO `ip_logs` VALUES ('2', '1156249416', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156311688', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('2', '1156321851', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('2', '1156322197', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('2', '1156322296', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('2', '1156322448', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('2', '1156322572', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('2', '1156322589', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156380835', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156490805', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156552885', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156739022', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156776101', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156925013', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156936604', 'ipaddress');
INSERT INTO `ip_logs` VALUES ('23', '1156936994', 'ipaddress');

The above can easily be changed by unselecting “create bulk sql statements” but that is one more job for me to do. Make sure your default format is the best

[jack111]

Hi,

Been testing both for a week now.

SQLyog is not a good brand name as I was wondering what it was but navicat is quiet clear. When google brought up the SQLyog result I almost did not click on it as I though it was to do with something else. So if SQLyog could be named as something else or the name put simply as sqlyog probably make it an easier brand name to catch on to.

I very much doubt it is a network issue but will test it out again. In this busy world frist impressions count a lot.

Navicat so far is much quicker, smoother and easier to understand and execute.

Probably SQLyog like an old wine is a more developed taste.

But I only have so much time and if SQLyog does not deliver soon will be leaving it however much I want to keep it.

jack111 wrote on Sep 7 2006, 08:33 AM:

also have you tried executing any 15mb sql script on a remote machine using both navicat and SQLyog. Do that than you will know what I mean

[jack111]

Let me start by saying that I believe you: 😀 That is a good start.

1) We don't have any issues in refunding the money. You can ask for a refund anytime! We have had just 1 refund request in the history of SQLyog!…………………………..well donot make it two than.

2) Could you post the sample script? I promise to post the profile results of both the products in this “public” forum…………….cannot give you the sql script as it contains articles from mysite. try it with any 15mb sql script. the results are not script specific. The sql file was created by phpmyadmin.

3) Structure Sync – Could you tell us the EXACT problems? Your “generic”, “ambiguous” and “negative” comments wont help any of us

………………………………………………well the problems is simple I donot know how to synchronise the structure of the database . I can synchronise data the instructions are clear but when I try and synchronise the structure I am lost.

I go to tools and than select the structure synchronization tool and than have tried the various options given below like copy sync sql to clipboard etc nothing seems to happen.

A BIT MORE IMPORTANT INFORMATION ABOUT HOW I AM USING SQLyog

I am using the SQLyog SSH tunnel to connect to a freebsd 5.4 server remotely from a windows xp pro machine in another continent and than manage my databases. using mysql 4.1

I have used mysqlcc and phpmyadmin.

Currently trying out NAVICAT and SQLyog

Quote:

Nope! SQLyog is compiled with the MySQL client API. The script is executed from the client! It does not 'upload' in the sense that there is no file transfer…………………..

I am using the SQLyog SSH tunnel to connect to a freebsd server remotely in another continent and than manage my databases. using mysql 4.1. Now when I tired to execute the sql file I had to wait for it to upload frist whether it was an upload or something else I donot know but I had to wait for about 10 minutes and than had to click on the execute button to execute the script I gave up midway . with navicat the entire process took about 4 minutes.

Please also answer: with what program was the .sql script generated? ………….phpmyadmin

I find in general navicat quicker at executing querries. I am no expert I go by what my experiences are.

[Author]

Posts