[peterlaursen]

Please search a little! 😛

http://www.webyog.com/forums//index.php?sh…view=getnewpost

(this post was actually visible form the Forums entry page!)

[peterlaursen]

Quote:

Either you believe me, or you don't.

We will have to look into if there is some difference with the TCP implementation on XP compared to previous versions that could have this effect.

Quote:

If this is addressed somewhere in the documentation, I could not find it…

nope it is not adressed. I also do not think we support this authentication. There is no setting for entering the PRIVATE KEY info either.

I will call in assistance here! 🙂

[peterlaursen]

Quote:

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

Could you please point me to the Navicat Forum? How do I talk to them at all? Does Navicat have a public issue tracker? And we are absolutely not losing to them or anybody else at the moment! That I can assure you!

Do you find any other third party MySQL client given space on the MySQL website as this?

http://dev.mysql.com/tech-resources/interv…ani-webyog.html

as most users do not stick around as long as me

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

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

You are welcome to propose anything. We have a few (!) other proposal. What will be implemented in the next update(s) is roughly being described here:

http://www.webyog.com/faq/33_20_en.html

[peterlaursen]

Quote:

This behavior occured on two computers with Win98 and another one with Win2k. However, as I found out today, with WinXP it works from the first day already.

I do not believe that the OS should nmake any difference. I think there was a server problem!

[peterlaursen]

OK ..

do not be mistaken! Now after import isn't everything as it should be?

SQLyog will need to create a table and next drop it and THEN create the View. The 'mysqldump' program does exactly the same. This is a 'workaround' for situations that can occur with VIEWs built on VIEWs for instance. A SQL dump is sequential. When the beginning is executed the end is not known! And if the second of those views is attempted created before the first you'll get an error. This way you don't!

You have not 'shortened'/edited the dump?

“I'm using sqlyog 5.16 community version” There is no such thing! You mean FREE 5.16 version I think!

[peterlaursen]

There is no printing option, that is correct.

Neither as simple 'text' printing or 'report-style' (lay-out'ed result) printing.

No plans either for the near future.

You will have to copy.

For instance edit .. select all (in the editor) ..copy (into clipboard).

If it is results you can 'show results in text'

[peterlaursen]

Quote:

but i noted in the generated SQL code that TRIGGER become TABLES!

?????????? sorry for all the question marks !!!!!!!!!!!!!!!!

Can you provide an example please? (a conflicting screenshot and dump for instance!)

Also: ALWAYS tell what program version you are using

I just did this example with 5.18 and it is coorect:

Code:

*
SQLyog Enterprise – MySQL GUI v5.18
Host – 5.0.24a-community-max-log : Database – test
*********************************************************************
Server version : 5.0.24a-community-max-log
*/

SET NAMES utf8;

SET SQL_MODE='';
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';

/*Table structure for table `TableName1` */

CREATE TABLE `TableName1` (
`id` bigint(20) NOT NULL auto_increment,
`txt1` varchar(20) NOT NULL,
`num1` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `TableName1` */

insert into `TableName1` (`id`,`txt1`,`num1`) values (1,'',0);
insert into `TableName1` (`id`,`txt1`,`num1`) values (2,'',0);

/*Trigger structure for table `TableName1` */

DELIMITER $$

CREATE TRIGGER `nope` AFTER INSERT ON `TableName1` FOR EACH ROW BEGIN
END$$

DELIMITER;

SET SQL_MODE=@OLD_SQL_MODE;

[peterlaursen]

Unfortunately there is nothing of what you say that can be used constructively.

Webyog Ofiice is in India, I work from Denmark, The webyog.com serveris in California, USA. We freqquently use SQLyog for database operations involving lot of data. This Forums database for instance is about 40 MB (without the log tables), our cusotomer/user database about 60 MB, FAQ about 25 MB. I work on all of them interactively from SQLyog every day. And have been doing backup, restores and data sync too.

All the data are 'mirrored' to a Sever in Bangalore and some of them to my Linux box. SQLyog does it all. (we DO use 'mysqldump' as a CRONJOB on the server however!).

Now give us some information, some data and a test case, and we shall publish the results!

“SQLyog is not a good brand .. but Navicat .. ” True, some people mistake the price and the quallity <_<

Quote:

with SQLyog the back file leave details in a horizontal format

Holy Cow! You can configure that as you want. menu .. tools .. set BULK size to 0 (=zero) and you will get 1 INSERT statement per row of data!

Read: http://www.webyog.com/faq/24_101_en.html

And with the Backup 'powertool' (that you paid for!) there are even more options!

[peterlaursen]

Hello again!

What is the staus with this one?

[peterlaursen]

“Then if you click another table, the edit cell remains active.” Not reproducable here if I understand right! What is your program version? This 'mouse control thing' was 'worked over' in 5.17.

However YES if you mean “Then if you click another DATABASE …. “.

Were are clicking in the Object Browser, right?

Spellllllllllllllllllllllllllllllllllllllling error ???? 😀

[peterlaursen]

“noticed that I have a not null contraint on one of the columns that was missing from the statement in question”

Ok .. as you had a NOT NULL in the definition what was than inserted into actual column? An empty string? A '0' (zero) ?

What is the MySQL version? It looks like an issue with MySQL 5 and strict_mode. Read about SQL_modes:

http://www.webyog.com/faq/28_72_en.html.

An example:

with this definition:

Code:

CREATE TABLE `TableName1` (
`id` bigint(20) NOT NULL auto_increment,
`txt1` varchar(20) NOT NULL,
`txt2` varchar(20) default NULL,
`num1` bigint(20) NOT NULL,
`num2` bigint(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

this SQL

Code:

insert into TableName1 (txt2, num2) values ('blabla',47);
select * from TableName1;

raises no error and returns

Code:

id txt1 txt2 num1 num2
—— —— —— —— ——
1 blabla 0 47

This is the SERVER behaviour in 'non-strict' mode.

Every GUI tools sets the sql_mode = ''.

It would raise too many problems with a GUI if they did not!

and BTW: before MySQL 5.0 the server behaviour was ALWAYS 'non-strict'!

[peterlaursen]

hmmm ..

Do both fields have an index? That looks like a pretty trivial FK thing that should not normally create any problems! And both tables are InnoDB?

“I am receiving an error on the FK creations” There is no more information about the error? an error no.? an error message?

[peterlaursen]

Also the 'mysqldump' program uses this.

From http://dev.mysql.com/doc/refman/5.0/en/inn…onstraints.html

Quote:

To make it easier to reload dump files for tables that have foreign key relationships, mysqldump automatically includes a statement in the dump output to set FOREIGN_KEY_CHECKS to 0. This avoids problems with tables having to be reloaded in a particular order when the dump is reloaded.

I always mismatch this 🙁

Correct is “FOREIGN_KEY_CHECKS”, “FOREIGN_KEYS_CHECK” is wrong!

[peterlaursen]

did you check the 'SET FOREIGN_KEYS_CHECK = 0″ box?

http://dev.mysql.com/doc/refman/5.0/en/set-option.html

Quote:

FOREIGN_KEY_CHECKS = {0 | 1}

If set to 1 (the default), foreign key constraints for InnoDB tables are checked. If set to 0, they are ignored. Disabling foreign key checking can be useful for reloading InnoDB tables in an order different from that required by their parent/child relationships. See Section 14.2.6.4, “FOREIGN KEY Constraints”.

Actually 'circular references' are possible and then there is NO TABLE ORDER 'that saves the day' !

The Foreign_keys_check option is for that.

[peterlaursen]

And you are sure that network connection was equally good and the server was performing identically when you tried the different programs? Looks like it was a networking issue that occurred, or the server had a problem!

You cannot compare things this way in my opinion. Now we have a 3 moths money-back guarantee, so there is plenty of time! For how long have you been trying SQLyog (and Navicat) ?

[Author]

Posts