[dany]

Hello Daniele,

 

There is ‘Hide Language Options’ where charset and collation columns are hidden. You can uncheck the option to see the column charset and collation. Please find the screenshot attached.

 

 

Regards,

Sathish

 

Hello Sathish,

thank you very much!

 

It works!

 

Best Regards,

Daniele

[dany]

Yes!

SQLyog 6.12 n3 works.

[dany]

Just to let you know,

I did some little test on a Windows XP computer and I can confirm that

this bug was present also in SQLyog 6.07 enterprise.

Bye

[dany]

Raising the max_allowed_packet value in server configuration solved the import issue.

Thanks 🙄

I think you should try to reproduce the program crash lowering the max_allowed_packet value.

Yesterday SQLyog crashed every single time i tried to import that DUMP file right after the “MySQL server has gone away” error.

Daniele

[dany]

This is what the DUMP file looks like

I've skipped to the (let's say) 'aaa' table.

The problem arises when SQLyog is doing the INSERT INTO.

That INSERT INTO is very, very long.

I will do more tests this night.

Bye,

Daniele

/*

SQLyog Community Edition- MySQL GUI v6.1

MySQL – 4.1.22-community-nt : Database – az1001

*********************************************************************

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

create database if not exists `az1001`;

USE `az1001`;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*Table structure for table `aaa` */

DROP TABLE IF EXISTS `aaa`;

CREATE TABLE `aaa` (

`id` int(10) unsigned NOT NULL auto_increment,

`aaa1` smallint(6) NOT NULL default '0',

`aaa2` smallint(6) default NULL,

`aaa3` int(11) NOT NULL default '0',

`aaa4` int(11) default NULL,

`aaa5` int(11) default NULL,

`aaa6` int(11) default NULL,

`aaa7` char(18) default NULL,

`aaa8` char(18) default NULL,

`aaa9` char(80) default NULL,

`aaa10` int(11) default NULL,

`aaa11` decimal(12,3) default NULL,

`aaa12` decimal(12,5) default NULL,

`aaa13` decimal(4,2) default NULL,

PRIMARY KEY (`id`),

KEY `indexaaa6` (`aaa6`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED COMMENT='InnoDB free: 7168 kB';

/*Data for the table `aaa` */

insert into `aaa`(`id`,`aaa1`,`aaa2`,`aaa3`,`aaa4`,`aaa5`,`aaa6`,`aaa7`,`aaa8`,`aaa9`,`aaa10`,`aaa11`,`aaa12`,`aaa13`)

values (2,1,NULL,9,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL)

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

[dany]

If you double click the “Unique” flag (or press the edit button) you can uncheck it.

Daniele

[dany]

This table comes from a MySQL 5.0.21 server.

Similar problem on a similar table in a MySQL 4.1.x server.

Here is the CREATE TABLE COMMAND:

/*

SQLyog Enterprise – MySQL GUI v5.12

Host – 5.0.21-community-nt : Database – aaa

*********************************************************************

Server version : 5.0.21-community-nt

*/

SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `aaa`;

USE `aaa`;

DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (

`id` int(11) NOT NULL auto_increment,

`codice` char(5) NOT NULL,

`a2` char(25) NOT NULL,

`a3` char(100) NOT NULL,

`a4` decimal(6,2) NOT NULL default '0.00',

`a5` int(11) NOT NULL default '0',

`a6` int(11) NOT NULL default '0',

`a7` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

UNIQUE KEY `indexCodice` (`codice`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED;

[dany]

In this moment I'm using SQLyog 5.11 Enterprise.

See attachment:

Without the “NOT NULL” flag I can insert “Default” and it is saved in the row as a string.

[dany]

Hi Peter,

first of all remember to change the last update date in the FAQ 🙂

I think that the behavior of SQLyog should be different:

if you right click the cell and choose “Set to default” the cell is filled with “(Default)”

The very same thing should happend when you try to manually insert “Default”: it should be changed to “(Default)” when you change row so that you understand what is happening.

I think it is very strange that SQLyog does not understands the “Default” keyword if you define field b (in my example) as a char(10) without enabling the “NOT NULL” flag.

Daniele

[dany]

Hi,

I hope they will fix this bug in version 5.12.

Daniele

[dany]

Hi Ritesh,

version 5.02beta it's working better.

But there's still a small thing that can be fixed.

1) use the “Import From SQL Statements” function to import a database that will get to the last position in the Object Browser

2) press F9 to refresh the Object Browser

3) even if you click on the database name SQLyog will not select that database as the active database.

Daniele

[dany]

Hi,

these are the first lines of the dump file:

create database if not exists `yyy`;

USE `yyy`;

SET FOREIGN_KEY_CHECKS=0;

By the way this bug was in SQLyog at least from V. 4.07.

Bye

[dany]

Try this:

1) Open Excel and select all the columns you will fill

2) Go to the “Format” menu

3) Select “Cells”

4) In the “number” page select “text”

5) Now you can do copy and paste.

Bye

[dany]

OK.

I can beta test the program using MySQL version 3.22, 4.0 and 4.1

Bye

[dany]

Hi Ritesh,

any news?

[Author]

Posts