MySQL Forums - Workbench - Newbie

Change the workbench character set for server connections (2 replies)

Robb Wagoner — Mon, 23 Nov 2009 19:48:00 +0000

I am trying to use MySQL Workbench 5.2 BETA to connect to MySQL 4.0. I am getting an error: "Unknown character set: utf8"

MySQL 4.0 doesn't support utf8 character set, hence the error.

My server is using latin1. I need to change Workbench's behavior to use the latin1 character set, which along with other character sets, looks to be defined in this file: /usr/share/mysql-workbench/modules/data/mysql_rdbms_info.xml.

I've tried altering my ~/.mysql/workbench/connections.xml to add
"com.mysql.rdbms.mysql.charset.latin1" to the connection in question. However, it doesn't seem to affect it as I'd expect. I still get the error.

Can someone kindly provide some insight on how to do this with Workbench?

Thanks,
Robb

MySQL Workbench 5.2.8 (BETA 1): Upgrade from MySQL Administrator, MySQL Query Browser (no replies)

Edwin DeSouza — Wed, 18 Nov 2009 19:37:38 +0000

WB 5.2.8 includes:
- 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/

New to Workbench (1 reply)

ashr ben — Fri, 13 Nov 2009 19:28:57 +0000

Using mysql admin, backup was easy. I cant find backup in workbench, where is it using mysql 5.4.

Right panels disappeared (1 reply)

Fri, 13 Nov 2009 17:30:03 +0000

Hi everybody,

I installed Mysql Workbench 5.1.18 yesterday.
I tryed it. Marvellous!

This morning I opened it but the vertical panels on the right (catalog, description, zooming area) have disappeared.
on the EER diagram, I only have the main view where I put my tables on the grid.

If this is normal, what is the trick to make them disappear and come back?

Thank you in advance for your help.

Gary

Updating a column datatype (1 reply)

Mike Chibaka — Mon, 09 Nov 2009 08:39:03 +0000

Friends,

I've installed mySQL workbench 5.1.18. I have a scenario like this in my model...

1. TableX has 2 columns ID_X(INT) PK, and ColX(INT)
2. TableY has 3 columns ID_Y(INT) PK, ID_X(INT) FK and ColY(INT)

note that ID_X from TableX is FK in TableY.

My question is, When I change the datatype of column ID_X from TableX to say VARCHAR, I expected TableY column ID_X to automatically change too (Being a foreign key). This is not happening :(

Am I goofing somewhere or this feature is not implemented???

Mike.

Insert text records from text file into a DB (-1 replies)

akra geba — Mon, 09 Nov 2009 01:25:15 +0000

-- moved topic --

can multiple eer diagrams be exported to one PDF document? (2 replies)

Kevin Schuelke — Tue, 10 Nov 2009 02:36:09 +0000

Tired of selecting one eer diagram, exporting it, selecting another, exporting it, etc, and then ending up with multiple pdf files. Can this be done in any edition of Workbench?

How do you remove mydb (4 replies)

Geoffrey Hoffman — Thu, 12 Nov 2009 19:09:18 +0000

I've imported (reverse engineered) an existing database and built a nice looking ERR diagram. The database is listed second under Physical Schemata. I cannot figure out how to remove the default mydb still there with nothing in it. How?

ER Diagram extension (1 reply)

Yannick Gaspar — Mon, 09 Nov 2009 08:48:36 +0000

I am trying to work with mysql workbench but im not finding how to make a table extension from another. Like Table X extends Table Y. How can i do that?
Thx.

manage connection (1 reply)

Jan Broekhuizen — Tue, 10 Nov 2009 13:27:56 +0000

Hello,
I run Ubuntu 9.10 under parallels desktop on a mac.
Everything works fine.
I have installed MySQL administrator, Querybrowser and Navigator.
These app's also work fine.
Then I installed the workbench.
When I try to manage a connection I get the following message:
Connection 'New connection 1' could not be established: Couldn't load library libmysqlclient_r.so:
When I do a Find for libmysqlclient_r.so the library is found.
So what do I do wrong?

By the way I do not see entries for Database system and Driver in the screen for manage DB connections. There is no DB connection editor as described in the documentation.

Hope to hear from anyone soon.

EER Diagram does not work (2 replies)

Jennifer King — Fri, 13 Nov 2009 01:41:48 +0000

Hello:

My setup: CentOS 5.3, MySQL 5.4 on a LINUX Server. WinXP 64 Bit PC connects to the LINUX machine. Workbench MySQL Workbench 5.2 OSS is installed on WinXP 64 Bit PC.

Few months ago I tried Workbench 5.1.16 and created a 'tibdb' DB on the LINUX machine. The I created a 'CustomerValidation' record. I dropped Workbench on recommendation of other MySQL users because it was outdated.

Today after removing the Workbench 5.1.16 from the WinXP 64 Bit machine, I installed Workbench MySQL Workbench 5.2 OSS. Connection from the WinXP 64 Bit PC to the LINUX server works. So far so good.

On the Workbench the EER Diagram is blank. I followed the Workbench Manual (Section 4.1.1) and try to add the 'CustomerValidation' table from the Catalog panel. The Workbench documentation says:

" You can add tables to the EER Canvas by picking them up from the Catalog panel and placing them on the Canvas."

Well, I have tried picking up the 'CustomerValidation' Table from the Catalog Panel and when I drop on the Canvas, nothing happens.

I know that was worked in version 5.1.16, but why it is not working now, is beyond my imagination! FYI, I can add a new Table on the Canvas, if that is any help.

Please HELP. Workbench looks like a good product and want to use it!!

Thanks in Advance.

Jennifer

Reverse Engineer Views (1 reply)

Dave Cosgrove — Mon, 02 Nov 2009 06:58:36 +0000

Using release 5.1.18, I reverse engineered a schema consisting entirely of views, and, once the process completed I am left with an oval icon per view without any columns/datatypes details. Is this all i should see for reverse engineered views?

Thanks in advance,

Dave

TINY print using Workbench OSS Community V5.1.18 (2 replies)

Gabe Tucker — Tue, 10 Nov 2009 20:12:52 +0000

Hi,

I am using Workbench Community to create an ERR Diagram of our databases.

The Table Objects on the virtual page are very small. So small that when I print the Diagram, it is useless.

How can I increase the size of the objects?

Thanks
- Gabe

MySQL Workbench 5.2.6 (ALPHA): SSH-Tunnel, Administrator, Query Browser (no replies)

Edwin DeSouza — Wed, 21 Oct 2009 21:21:56 +0000

WB 5.2.6 now includes:
- 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

How to work with MySQL Workbench and Subversion (1 reply)

pas cingo — Thu, 22 Oct 2009 06:41:17 +0000

Hi all,
I'm involved in the develop a database model using MySQL WB.
I want to use a revision control system like svn to manage the project .mwb file inside the development team to share the last version of the model.

But svn seems to be not able to check the file .mwb because of its format.

Exists any solution (e.g. plugin) to that problem?
How can I put under version control system the .mwb file?
Could anyone suggest to me how to manage the project file inside the team in order to keep everybody updated?

Sorry for my english that and thank you in advance for your advices.
pas

Reverse Engineer - No relationships shown (1 reply)

Michael Ryding — Thu, 22 Oct 2009 06:43:10 +0000

I'm new to this so apologies now if this is a REAL newbie question but....

I'm using:
Workbench 5.1.18 Community
Workbench 5.2.4 Community Alpha
MYSQL Database 5.1.39 community

I've used 'reverse engineer' to ERD from a (LifeRay Portal) MYSQL database and the diagram has all the tables, colums, keys etc but does not draw/connect the tables with relationship lines. Am I doing something wrong or do I have to manually make the connections on the diagram after it has been created? Thanks

Layout and formatting of EER Diagrams (12 replies)

Geoffrey Hoffman — Wed, 21 Oct 2009 06:44:03 +0000

How did they create the background layer behind the tables, for the table group Customer Data (orange) and Inventory (light blue) and Business (green) in the second screenshot here:

http://wb.mysql.com/?page_id=35

?

This EER diagram looks awesome but I can't figure out how do to it.

Also, I wish I could set the page size (e.g. to Tabloid 11x17). Is that possible?

2 more ... (1 reply)

Je Dev — Wed, 11 Nov 2009 19:15:00 +0000

Hi there

I start using Workbench to easily track my project evolution. I created the schema of one of my project but when I close the program and reopen it every small table are not showing the columns but indicating a small text with "2 more...".
How can I make Workbench always show me the entire list of columns for the tables I create?

Best regards

Windows Library Install (1 reply)

Michael Perata — Fri, 16 Oct 2009 06:39:59 +0000

Definitely a Newbie question!!
I did a forum search and couldn't find an answer, but where do I install the libraries I downloaded?
I am using Workbench 5.1.18 on a 64bit Windows 7 RTM machine.

Installing Workbench in PCLinuxOS distro. (1 reply)

Jamar Elephas — Tue, 13 Oct 2009 16:34:26 +0000

I would dearly love to be able to have MySQL WorkBench 5.1.18 [or there abouts] installed on my PCLinuxOS 2009 system .... i currently have a local web server running Apache, MySQL and PHP and am forced to go back to XP each time i need to address database design issues for small projects i am doing.

I have searched the web and found that version 5.1.18 is indeed cross-platform and there are Linux versions, available in either RPM or DEB packages .... none will install on my distro due to many dependency issues!

AND when i try to use the Synaptic Package Manager to install MySQL Workbench, i get the very first Alpha release from way back in 2007!?!?! ... i am sure u can imagine its state of maturity.

Question is: "Is there a way to get the latest stable version of MySQL WorkBench installed on PCLinuxOS 2009?"

I would be more than appreciative if there is

*smile*

Thnx

Edit table (1 reply)

Frans van Bussel — Fri, 16 Oct 2009 06:44:16 +0000

Well, I'm a newbie with MySQL and the MySQL Workbench.
With Workbench I've a problem.
I created a MySQL schema and added a table, I cannot edit the table via right click then edit table.
Has somebody an idea what I did wrong?

Error message:
Cannot load selected plugin(.\....wbp.fe.dll::DbMysqlTableEditor)

And this message in the GRT shell:
Starting Workbench...Registered 144 GRT classes.
WARNING: error calling getModuleInfo() in lua module C:\Documents and Settings\Frans\Application Data\MySQL\Workbench\modules\wb_library.grt.lua: attempt to call a nil value

WARNING: Could not load catalog_utils.grt.lua: Duplicate module WbUtils

WARNING: Could not load table_utils.grt.lua: Duplicate module WbTableUtils

WARNING: Could not load tools.grt.lua: Duplicate module WbTools

Registered 14 modules (from 12 files).
Looking for user plugins in C:\Documents and Settings\Frans\Application Data\MySQL\Workbench\modules
Looking for user plugins in C:\Documents and Settings\Frans\Application Data\MySQL\Workbench\plugins
Looking for plugins in C:\Documents and Settings\Frans\Application Data\MySQL\Workbench\C:\Program Files\MySQL\MySQL Workbench 5.1 OSS
MySQL Generic Runtime Environment 4.1.0
Type 'help' or '?' for help. Type 'quit' to exit the shell.
Welcome to the Lua Shell.
Ready.

problem with mysql procedure (-1 replies)

sandeep reddy — Thu, 08 Oct 2009 05:28:43 +0000

-- moved topic --

MySQL Workbench 5.2.4 (ALPHA): SSH-Tunnel, Administrator, Query Browser. (no replies)

Edwin DeSouza — Thu, 08 Oct 2009 00:08:24 +0000

WB 5.2.4 now includes:
- 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

Workbench 5.2 SSH-Tunnel connect to mySQL v5.1 Database (1 reply)

Carla Clark — Thu, 08 Oct 2009 07:27:57 +0000

I downloaded the mySQL Workbench 5.2 OSS to my PC. I'm trying to connect to a mySQL v5.1 for Bugzilla database on the Server. Using the Connection method of Standard TCP/IP over SSH. Normally to logon to the Bugzilla database I need to go into a Putty session. I cannot connect and have no clue what I'm doing.

This is what I have input into the Manage DB Connections:
SSH Hostname: systemswiki (Use this to connect in a Putty session)
SSH UserName: webadmin (use this in Putty session to login initially)
SSH Password: ******** (password to login to Putty session)
SSH Key File: /etc/ssh/ssh_host_dsa_key.pub

MySQL Hostname: systemswiki Port: 22
Username: root
Password: ********
Default schema: bugs

Can anyone explain this, guide me in the right direction or send me some examples?

Thank you for your help!

CC

INSERT into two relational tables (-1 replies)

Matthew Millar — Wed, 07 Oct 2009 07:38:32 +0000

-- moved topic --

How WB forward engineers different cardinalities (no replies)

Very Nosey — Tue, 06 Oct 2009 17:01:37 +0000

How does cardinality in the ER diagram affect the SQL create script?

I can have nearly identical ER diagrams with the only difference between them being 1:1 or 1:n. When I forward engineer the diagram however, the SQL create scripts are identical (line by line) regardless of cardinality. It seems like the scripts should be different in some way to reflect the different cardinality, but then again, I'm still learning.

PK consists of two columns (1 reply)

melmar melmar — Thu, 08 Oct 2009 08:21:21 +0000

Hi, how can create a PK consists of two columns ?

Inserting data in a table (no replies)

Robert Rogerson — Fri, 02 Oct 2009 17:20:25 +0000

I am using Workbench 5.1.18 OSS on Windows XP

I created a table and wish to populate it with sample data after forward engineering. I go to the INSERTS tab and I must click the Open Editor button.

Is there a way to get around using the editor so that I can export what is currently in the table and use this to build the insert statements?

Thanks,

Rob

Defining Foreign Key Indexs as INDEX or FOREIGN / Can't choose right key for FK-relationship (no replies)

Andreas Pankratz — Thu, 01 Oct 2009 10:39:55 +0000

Version: 5.1.18.a/Windows

Currently iam remoddeling an old Fabforce Model

old FK-relationships come with an extra index of the type INDEX

I just created a new FK-relationship using the Workbench, then i got a new index of type "FOREIGN". When iam creating the SQL Script i get an index of typ INDEX, as expected btw. But that's the sense of that FOREIGN type, is it just to make it easier to see its an FK-index?, or was it implemented for upcoming MySQL versions supporting this type?

Update:

As i just saw i cant change from FOREIGN to INDEX or otherwise, is tehre any possibility to change it?

Update2:

For some tables i have a change problem now: Iam creating a new FK, but if i want to set the column in the dropdown of "Referenced Column" i cant't see the primary of that table to choose, but one other non-indexed column. Any ideas?

Kind Regards
Andreas Pankratz

Getting connected (1 reply)

Phil H — Wed, 30 Sep 2009 19:06:34 +0000

Hi there, just down loaded this tool, it looks really great.

I'm having some trouble getting connected as there does not seem to be enough variables

I go to manage connections to set up a connection

My host name (that I use in my programs) is sqlx.bravehost.com
I know my user name & password but is this the database password or the one that links me to the hosting place
I cant see where to enter the database name

Am I missing something :-)

I hope you can help, this looks an awesome tool

Phil