Forum for general discussions about MySQL Workbench. http://forums.mysql.com/list.php?153 Tue, 24 Nov 2009 20:32:11 +0000 Phorum 5.2.1-alpha http://forums.mysql.com/read.php?153,291800,291800#msg-291800 http://forums.mysql.com/read.php?153,291800,291800#msg-291800 - Model (upgrade from DBDesigner)
- Query (upgrade from MySQL Query Browser)
- Admin (upgrade from MySQL Administrator)
- SSH-Tunnel (new)

Quick-Start Tutorial:
http://wb.mysql.com/?p=406

Download WB 5.2:
http://dev.mysql.com/downloads/workbench/]]> Edwin DeSouza Workbench - Database Modeling Wed, 18 Nov 2009 19:45:06 +0000 http://forums.mysql.com/read.php?153,291237,291237#msg-291237 http://forums.mysql.com/read.php?153,291237,291237#msg-291237 Table1: PatientInfo
Table2: Study
Table3: Series
Table4: Images

A Patient Can have 0 or more Studies.
A Study can have 1 or more Series.
A Series can have 1 or more Images.

I have a PatientID, StudyID, SeriesID and an ImageID which are all unique identifiers for each table.

When I am drawing the entity relation ship diagram and want to link the two tables, i.e. link PatientInfo >>-----> StudyInfo
What table element (if any) do they share?]]> Brian O'Brien Workbench - Database Modeling Fri, 20 Nov 2009 08:03:54 +0000 http://forums.mysql.com/read.php?153,291042,291042#msg-291042 http://forums.mysql.com/read.php?153,291042,291042#msg-291042
I have searched the forum here, but to no avail. At the end of a CREATE TABLE statement when you create a federated table , there is a connection table option, and as the manual states: "Before MySQL 5.0.13, use COMMENT rather than CONNECTION"

My question is, how to add a connection string to a federated table creation statement in Workbench? I regularly use version 5.1.18 (for Windows) but have also checked the most recent Apha, but there does not seem to be a way of adding the connection string and using "CONNECTION=". I just tried it and exported the schema and not surprisingly I got this mangled mess:

COMMENT = 'CONNECTION=\'mysql://reader:secret_password@ipaddress/database/table\'';

Is there a way of doing this, or am I going to have to edit the export every time?

Thanks in advance,

Stephen]]> Stephen Barton Workbench - Database Modeling Mon, 16 Nov 2009 08:10:40 +0000 http://forums.mysql.com/read.php?153,290799,290806#msg-290806 http://forums.mysql.com/read.php?153,290799,290806#msg-290806 Nisha Chandran Workbench - Database Modeling Thu, 12 Nov 2009 05:06:09 +0000 http://forums.mysql.com/read.php?153,290793,290793#msg-290793 http://forums.mysql.com/read.php?153,290793,290793#msg-290793 http://kontrollsoft.com/archives/522
http://kontrollsoft.com/downloads/kontrollbase_schema-rev219.pdf]]> Edwin DeSouza Workbench - Database Modeling Thu, 12 Nov 2009 17:03:27 +0000 http://forums.mysql.com/read.php?153,288560,288560#msg-288560 http://forums.mysql.com/read.php?153,288560,288560#msg-288560
thanks]]> Marco Flores Workbench - Database Modeling Thu, 29 Oct 2009 22:41:21 +0000 http://forums.mysql.com/read.php?153,288081,289030#msg-289030 http://forums.mysql.com/read.php?153,288081,289030#msg-289030 Szabolcs Király Workbench - Database Modeling Tue, 27 Oct 2009 10:29:08 +0000 http://forums.mysql.com/read.php?153,287984,287984#msg-287984 http://forums.mysql.com/read.php?153,287984,287984#msg-287984
When I use MySQL Workbench to import a database creation script, it skips all the tables that specify 'storage disk' on a column.

It looks like MySQL Workbench does not understand the syntax for storing columns of ndbcluster tables on disk.

Is there a work-around for this?

What do other people do?]]> Mike van Lammeren Workbench - Database Modeling Tue, 27 Oct 2009 13:43:24 +0000 http://forums.mysql.com/read.php?153,287340,287340#msg-287340 http://forums.mysql.com/read.php?153,287340,287340#msg-287340 - MySQL Query Browser (Feature Complete)
- SSH-Tunnel (Feature Complete)
- MySQL Administrator (Not Complete yet)

We need your help, testing & feedback!

Download WB 5.2:
http://dev.mysql.com/downloads/workbench/

MySQLWorkbench: SSH-Tunnel
http://wb.mysql.com/?p=370

MySQL Workbench: Administrator
http://wb.mysql.com/?p=374

MySQL Workbench 5.2: Features of MySQL Query Browser
http://dev.mysql.com/workbench/?p=229

MySQL Workbench 5.2: QuickTour of Query Browser
http://dev.mysql.com/workbench/?p=230]]> Edwin DeSouza Workbench - Database Modeling Wed, 21 Oct 2009 21:23:14 +0000 http://forums.mysql.com/read.php?153,286926,286926#msg-286926 http://forums.mysql.com/read.php?153,286926,286926#msg-286926
I am looking to have bunch of columns created by default when a table been dragged and created on the canvas. Some thing like 'id' column gets created. It is a common practice on the larger DB designs which captures createdOn, updatedOn, activityStatus, userId ...etc on all the tables. I have 75+ entities that I have to model I don't want to create them by hand every time, it take long time to sync up all.

Wondering is the a snippet/script or plugin which can resolve such issue.

Appreciate your response/help.]]> Meher Saride Workbench - Database Modeling Wed, 21 Oct 2009 06:54:16 +0000 http://forums.mysql.com/read.php?153,286467,286467#msg-286467 http://forums.mysql.com/read.php?153,286467,286467#msg-286467 http://propel.phpdb.org/trac/
http://www.diloc.de/blog/downloads/PropelExport.grt.lua
http://www.diloc.de/blog/2009/10/14/mysql-workbench-propel-export-plugin-v05/]]> Edwin DeSouza Workbench - Database Modeling Fri, 16 Oct 2009 03:52:14 +0000 http://forums.mysql.com/read.php?153,286207,286207#msg-286207 http://forums.mysql.com/read.php?153,286207,286207#msg-286207 May I suggest an improvement to MySQL Workbench:

Currently, the column names and the column properties in the EER Diagram are both shown in the table box (which is very handy).

ex.: column_name INT(11)
col_name VARCHAR(255)

However this creates visual noise and the column name readability decreases dramatically. If you could make the properties of a lighter color (gray) than the column name, it would be a big plus to the visual modeling.

My compliments for the great software.

Slava]]> Slava Dev Workbench - Database Modeling Fri, 16 Oct 2009 06:46:30 +0000 http://forums.mysql.com/read.php?153,285361,285361#msg-285361 http://forums.mysql.com/read.php?153,285361,285361#msg-285361
http://semisolid.webvantage.com.au/dev/mywb.jpg

If you notice that there is a strange little graphic where a table should be, the specified table has disappeared, but still shows under the catalog section of the program.

I synch okay with the database no issues there but this graphical error has me a bit concerned.]]> James Biviano Workbench - Database Modeling Sun, 22 Nov 2009 07:02:20 +0000 http://forums.mysql.com/read.php?153,285106,285106#msg-285106 http://forums.mysql.com/read.php?153,285106,285106#msg-285106 - MySQL Query Browser (Feature Complete)
- SSH-Tunnel (Feature Complete)
- MySQL Administrator (Not Complete yet)

We need your help, testing & feedback!

Download WB 5.2.4:
http://dev.mysql.com/downloads/workbench/

MySQLWorkbench: SSH-Tunnel
http://wb.mysql.com/?p=370

MySQL Workbench: Administrator
http://wb.mysql.com/?p=374

MySQL Workbench 5.2: Features of MySQL Query Browser
http://dev.mysql.com/workbench/?p=229

MySQL Workbench 5.2: QuickTour of Query Browser
http://dev.mysql.com/workbench/?p=230]]> Edwin DeSouza Workbench - Database Modeling Thu, 08 Oct 2009 00:25:15 +0000 http://forums.mysql.com/read.php?153,284029,284029#msg-284029 http://forums.mysql.com/read.php?153,284029,284029#msg-284029 http://www.pythian.com/news/4162/free-and-easy-schema-diff-and-patch]]> Edwin DeSouza Workbench - Database Modeling Wed, 30 Sep 2009 16:38:59 +0000 http://forums.mysql.com/read.php?153,283344,283344#msg-283344 http://forums.mysql.com/read.php?153,283344,283344#msg-283344
anyway to fix this? now i will either create a relationship with the "Foreign Keys" tab. but its a bit more troublesome as i have to name the relationship myself and slower then placing relationships with clicks.]]> iceangel89 LLL Workbench - Database Modeling Mon, 28 Sep 2009 05:45:04 +0000 http://forums.mysql.com/read.php?153,282963,282963#msg-282963 http://forums.mysql.com/read.php?153,282963,282963#msg-282963 Ian Hayes Workbench - Database Modeling Mon, 28 Sep 2009 05:55:45 +0000 http://forums.mysql.com/read.php?153,282929,282929#msg-282929 http://forums.mysql.com/read.php?153,282929,282929#msg-282929
Is it possible to export the diagram as PDF in more than 1 page?

My diagram has too much to be fitted in single A4 page and my office has no A3 paper unfortunately.

If I can export the diagram in 2 or more pages, then I can print it in pages and the diagram will be much bigger.]]> Alan Tse Workbench - Database Modeling Mon, 28 Sep 2009 06:12:54 +0000 http://forums.mysql.com/read.php?153,282031,282031#msg-282031 http://forums.mysql.com/read.php?153,282031,282031#msg-282031
CREATE TABLE IF NOT EXISTS `global`.`tblCandidato` (
`idCandidato` INT NOT NULL AUTO_INCREMENT ,
`intFechaAlta` INT NOT NULL DEFAULT today COMMENT 'Poner la fecha de su alta a GlobalMx' ,
`intVigenteHasta` INT NOT NULL ,
`txtPaterno` VARCHAR(25) NOT NULL COMMENT 'No puede estar vacío' ,
`txtMaterno` VARCHAR(25) NULL COMMENT 'Puede ser vacío' ,
`txtNombre` VARCHAR(25) NOT NULL ,
`intSexo` TINYINT NOT NULL DEFAULT 0 COMMENT '0 para hombre 1 para mujer' ,
`intEstadoCivil` TINYINT NOT NULL ,
`intNacio` INT NOT NULL ,
`txtCorreo` VARCHAR(75) NOT NULL ,
`txtPass` VARCHAR(15) NOT NULL ,
`txtAlias` VARCHAR(45) NULL COMMENT 'Seudónimo para los que no quieren que se vea su nombre' ,
`txtDomicilio` VARCHAR(140) NULL ,
`intCodigo` SMALLINT NULL ,
`txtTelefonoContacto` VARCHAR(15) NULL ,
`txtTelefonoCelular` VARCHAR(15) NULL ,
`intHorarioContacto` TINYINT NOT NULL DEFAULT 0 COMMENT '0 es diurno 1 es nocturno' ,
`intAceptaCorrespondencia` TINYINT NOT NULL DEFAULT 1 COMMENT '0 para los que no quieren recibir y mostrar su domicilio personal, solo el Código Postal y el 1 para los que aceptan' ,
`intPromoverme` TINYINT NOT NULL DEFAULT 0 COMMENT '0 para mostrar el CV, 1 no lo promueve' ,
`tblPaises_idtblPaises` INT NOT NULL ,
`txtCualidad` VARCHAR(45) NULL ,
`txtDefecto` VARCHAR(45) NULL ,
`txtPasatiempo` VARCHAR(45) NULL ,
`intCV` TINYINT NOT NULL ,
`intCartas` TINYINT NOT NULL ,
`intEstudios` TINYINT NOT NULL ,
`intExperiencia` TINYINT NOT NULL ,
`intHabilidades` TINYINT NOT NULL ,
`intIdiomas` TINYINT NOT NULL ,
`intTrayectoria` TINYINT NOT NULL ,
`intFechaActualiza` INT NOT NULL ,
PRIMARY KEY (`idCandidato`) ,
INDEX `fk_tblCandidato_tblPaises1` (`tblPaises_idtblPaises` ASC) ,
CONSTRAINT `fk_tblCandidato_tblPaises1`
FOREIGN KEY (`tblPaises_idtblPaises` )
REFERENCES `global`.`tblPaises` (`idtblPaises` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
COMMENT = 'Contiene la información básica de un candidato'

And I get this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'today COMMENT 'Poner la fecha de su alta a GlobalMx' , `intVigenteHasta` INT ' at line 3

I hope someone can help me.

Best regards]]> Abraham Segura Workbench - Database Modeling Sat, 19 Sep 2009 05:17:58 +0000 http://forums.mysql.com/read.php?153,281394,281394#msg-281394 http://forums.mysql.com/read.php?153,281394,281394#msg-281394
Download WB 5.2.3:
http://dev.mysql.com/downloads/workbench/

MySQL Workbench 5.2: Features of MySQL Query Browser
http://dev.mysql.com/workbench/?p=229

MySQL Workbench 5.2: QuickTour of Query Browser
http://dev.mysql.com/workbench/?p=230]]> Edwin DeSouza Workbench - Database Modeling Tue, 15 Sep 2009 21:32:35 +0000 http://forums.mysql.com/read.php?153,281268,281268#msg-281268 http://forums.mysql.com/read.php?153,281268,281268#msg-281268
I'm using version 5.1.18 of WB on Windows. I have a number of EER Diagrams and WB allows me to manually resize the tables so that all columns and indexes are visible, but whenever I close and re-open WB it has forgotten the manual settings and has collapsed all the tables down and hidden most of the columns.

Is this a configurable option? As I am spending a fair amount of time resizing the tables each time I export the diagram to PDF or PNG.

Many thanks in advance,

Jonathan]]> Jonathan Wilmot Workbench - Database Modeling Wed, 16 Sep 2009 10:10:46 +0000 http://forums.mysql.com/read.php?153,281149,281149#msg-281149 http://forums.mysql.com/read.php?153,281149,281149#msg-281149
Also, I cannot add an existing table to an EER diagram by following the given instructions of "right clicking on the vertical toolbar". Right clicking does absolutely nothing on any of the toolbar options. Again, thanks for any help.]]> Ben Polk Workbench - Database Modeling Wed, 16 Sep 2009 06:09:15 +0000 http://forums.mysql.com/read.php?153,281070,281070#msg-281070 http://forums.mysql.com/read.php?153,281070,281070#msg-281070
For some reason it has added the mydb schema to my model and wants to add new tables to it by default.

How can I remove this schema from my model? The model page allows you to delete a schema but no option to select one. Also I cannot delete a table from this mydb schema as I can't select it. The Catalog tree doesn't have options for deleting either.

Thanks,

Damian.]]> Damian Harvey Workbench - Database Modeling Mon, 14 Sep 2009 10:49:11 +0000 http://forums.mysql.com/read.php?153,280847,280847#msg-280847 http://forums.mysql.com/read.php?153,280847,280847#msg-280847
diagram is not worth much without them.]]> Belinda Weinbrecht Workbench - Database Modeling Mon, 14 Sep 2009 06:46:33 +0000 http://forums.mysql.com/read.php?153,280493,280493#msg-280493 http://forums.mysql.com/read.php?153,280493,280493#msg-280493 I would like to add the command "ALTER TABLE foo AUTO_INCREMENT 100" to the SQL created by the Export->Forward Engineer SQL CREATE Script. I can add a procedure, but I can't see how to call it automatically. I don't want to have to modify the generated SQL script every time I generate it.

Regards,
Dan]]> Dan Cook Workbench - Database Modeling Mon, 14 Sep 2009 07:31:35 +0000 http://forums.mysql.com/read.php?153,280426,280426#msg-280426 http://forums.mysql.com/read.php?153,280426,280426#msg-280426
I've observed recently that a strange black dot is after the name on some tables in the catalog view. I can also see that when expanding the table only the primary key is visible on the fields list, while on the tables that do not have this strange dot all the fields are listed.

Am i missing something or is this a bug???

It began with the 5.1.18 release as far as i'm concerned

Any idea?]]> jaume mussons Workbench - Database Modeling Sat, 12 Sep 2009 15:36:19 +0000 http://forums.mysql.com/read.php?153,280065,280065#msg-280065 http://forums.mysql.com/read.php?153,280065,280065#msg-280065
Can someone please tell me what causes this and how to avoid/fix it?

Thanks,

Karel]]> Karel Chlebek Workbench - Database Modeling Wed, 16 Sep 2009 10:12:02 +0000 http://forums.mysql.com/read.php?153,280049,280049#msg-280049 http://forums.mysql.com/read.php?153,280049,280049#msg-280049
I am trying to add a FULLTEXT index to a column in a table using Workbench. I am using 5.2.1 Alpha for Linux (on Ubuntu).

The column in question is of data type 'TEXT'. So on the 'Indexes' tab in edit table, I have clicked on a new row, given the index a name, selected 'FULLTEXT' as the type, but then I am not able to select any of the checkboxes denoting columns, most importantly, the column I want to index.

Is this a bug I need to report, or am I missing something here?

Thanks,
Stephen]]> Stephen Barton Workbench - Database Modeling Mon, 07 Sep 2009 12:09:39 +0000 http://forums.mysql.com/read.php?153,279669,279669#msg-279669 http://forums.mysql.com/read.php?153,279669,279669#msg-279669
Latest fixes:
http://dev.mysql.com/workbench/?page_id=49

Download:
http://dev.mysql.com/downloads/workbench/5.1.html

Discussions:
http://forums.mysql.com/index.php?151]]> Edwin DeSouza Workbench - Database Modeling Thu, 03 Sep 2009 21:10:15 +0000 http://forums.mysql.com/read.php?153,279503,279503#msg-279503 http://forums.mysql.com/read.php?153,279503,279503#msg-279503 Is this a known limitation, a bug, or am I missing something so obvious I cannot see it? I've already tried to left and right click on the physiscal schemata borders and to use all the classic interaction means to "enlarge" the row, but to no avail.
Thanks in advance for any help or advice you can give me (apart from "reduce your number of DBs" :-)),

Matteo

PS
To reproduce what I'm sayng, just create some 10 DBs and try to select the last from the physical schemata view.]]> Matteo Artuso Workbench - Database Modeling Thu, 03 Sep 2009 09:51:55 +0000