[Stephan123]

Hello there,

Thanks for the information. I will prepare an experimental server .

This server is identical to the production server .

I send a mail when the server is ready.

With best regards

Stephan

[Stephan123]

Hello,

 

I use SQLYog version 12.1 and OpenSSL vers. 1.0.1k , 8 Jan 2015 on debian8 server.

 

Here is the my.cnf

 

…

 

[client]

ssl-ca=/ssl/ca-cert.pem

ssl-cert=/ssl/client-cert.pem

ssl-key=/ssl/client-key.pem

 

…

 

[mysqld]

ssl-ca=/ssl/ca-cert.pem

ssl-cert=/ssl/server-cert.pem

ssl-key=/ssl/server-key.pem

 

…

 

 

 

Sorry for my bad english.

 

 

Your sincerly

 

Stephan

[Stephan123]

Hello!

Sorry for my bad english.
We create in our company every day ‘scheme for databases‘.

 

This is necessary for people who do not have access to the database.
Is it possible to take over the table comment in the database schema?

 

 

Sincerely yours

 

Stephan

[Stephan123]

Hello !

That is correct. Thanks

[Stephan123]

Thanks

[Stephan123]

Hello!

I work with the MySQL version 5.5.8 on Windows.

The problem was solved. When I program the log file of mysql server is on. I have turned off this log. The command was

set global general_log = 'off'

The import of the data was carried out properly.

Why does the available space on the hard disk drive was so low I can not understand.

Sincerely yours

Stephan

[Stephan123]

Hello !

I think this is not the perfect solution. better is a way like a paginator.

Your sincerly

Stephan

[Stephan123]

Hello !

I've tried changing the comments.

The change of column comments worked.

Where can I see table comment ?

And where can i edit the table comment ?

In the moment i see the column comments in the 'query editor' -> 'info' .

I have a dream …

Is there a way to see the comments for the columns and the table in the

schema designer.

Here a little image.

Your sincerly

Stephan[attachment=1630:table.jpg]

[Stephan123]

Hello !

Thanks for the help.

I have found the error.

The extension of the xml file was wrong.

The correct extension is 'schemaxml'.

In the moment i test the designer.

I miss two things.

Where can I see or enter the table information ?

Where I can highlight areas of color ?

Your sincerly

Stephan

[Stephan123]

'Stephan123' wrote:

Hello !

Thanks for the answer.

In SQLYog i have one tab.

This tab is a 'schema designer' tab.

Now i open the xml file.

'File' -> 'Open'

A new query tab is open.

I see in this query tab the content of the xml file.

What is wrong ?

Here is the content of the xml file:

---

Code:

db1154036-hotels

82
29
121
158
CREATE TABLE `board_types` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`properties_id` INT(11) NOT NULL COMMENT 'Verknüpfung zur Tabelle ''properties''',
`code` VARCHAR(10) DEFAULT NULL,
`name` VARCHAR(45) DEFAULT NULL,
`description` VARCHAR(45) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_board_types_properties1` (`properties_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COMMENT='Tabelle der Verpflegungstypen'

259
34
134
158
CREATE TABLE `boardtype_prices` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`date_from` DATE DEFAULT NULL,
`date_to` DATE DEFAULT NULL,
`amount` FLOAT DEFAULT NULL,
`board_types_id` INT(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_boardtype_prices_board_types1` (`board_types_id`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COMMENT='Wenn separate eine Verpflegung zugebucht wird'

---

Your sincerly

Stephan

[Stephan123]

Sorry

[Author]

Posts