How do I enlarge an EER Diagram in MySQL Workbench?

Question

I am working on a moderately complex schema in MySQL Workbench, and the single page of the EER diagram is now full up. Does anyone know how to enlarge it to two or more pages?

score 463 · Accepted Answer · answered Feb 09 '11 at 10:44

463

On the Model pull-down there is an option Diagram Properties and Size, which allows the size of the diagram to be changed.

answered Feb 09 '11 at 10:44

Brian Hooper

21,544
24
88
139

1

Then ,you can also export a single page pdf. I prefer watching at the db as a big picture... – gdm Jan 14 '13 at 13:18
6

Dear MySQL, why this option is so hard to find? It should be displayed near the zoom tool. – COil Jan 14 '15 at 11:35
1

This option is greyed out for me :( – siliconrockstar Nov 03 '15 at 22:20
or just expand/contract it automatically like visio does. – JDPeckham Jul 06 '17 at 15:25
1

pull-down? A more popular name is `menu` – ACV Sep 24 '20 at 20:38
@ACV, I was traumatised by exposure to X/Motif at an impressionable age. – Brian Hooper Sep 25 '20 at 11:06

score 177 · Answer 2 · edited Mar 24 '14 at 11:43

177

ER Diagram -> Model -> Diagram Properties and Size...

Menu access

grid size

Menu access - windows

grid size - windows

edited Mar 24 '14 at 11:43

Michel Ayres

5,891
10
63
97

answered Mar 08 '14 at 10:22

d.danailov

9,594
4
51
36

Crap! I totally forgot about workbench, how long has it been around? I still use and download the GUI tools! – Alec Teal Mar 24 '14 at 11:43
This option is not there in new version of mysql workbench6.2 – RN Kushwaha Feb 20 '15 at 13:12
1

@RNKushwaha I use Mysql Workbench 6.2 and I have this option. Please try again. – d.danailov Feb 22 '15 at 21:05
I use mysql wb in window at home its there but in ubuntu its not. – RN Kushwaha Feb 23 '15 at 03:32
Ok, I understand. I use Yosemite. – d.danailov Feb 23 '15 at 05:41
1

Its there but its disabled. – RN Kushwaha Feb 23 '15 at 05:43
Finally I got the solution, Its not under model menu but in Arrange->model menu in ubuntu – RN Kushwaha Feb 23 '15 at 06:04

score 27 · Answer 3 · answered Jul 08 '17 at 22:21

If the "Diagram Properties and Size..." option is grayed out, do the following:

Save your work, as this may crash Workbench;
Go to Model > Model Options;
Choose the "Diagram" tab;
Uncheck "Use defaults from global settings..." at the bottom;
Confirm "Ok". This may crash Workbench, depending on the version and/or operating system.
Either way, "Model > Diagram Properties and Size..." should now be enabled, even if you had to reopen Workbench.

score 9 · Answer 4 · answered Apr 13 '17 at 13:13

9

In addition to the already told "diagram propertys" settings - where everything is measured in pages and where you can't enter float values to make slightly smaller or bigger. But you can change the page size itself: File->Page Setup

answered Apr 13 '17 at 13:13

Hexodus

12,361
6
53
72

score 8 · Answer 5 · answered Apr 09 '12 at 15:28

by the way, if you want a large number of schemas to display correctly, you need to increase the size of the canvas AND zoom out BEFORE running "Auto Layout". if you increase the canvas size enough and zoom out enough all the tables will be spaced apart nicely.

score 3 · Answer 6 · answered Apr 27 '13 at 23:14

3

If you are under Linux, and it is hanging when you try to elarge the canvas size, try zoomming out to the smallest view possible before changing the canvas properties.

Worked for me.

Regards, Leo.

answered Apr 27 '13 at 23:14

Leo Medeiros

154
1
3

score 2 · Answer 7 · answered Jan 26 '16 at 13:32

If option "Diagram Properties and Size" is disabled (grayed out) You can try to run MysqlWorkbench with sudo

sudo /usr/bin/mysql-workbench

I am not good at linux, there should be some miss-configuration leading to this. So I'am only saying that this resolved the problem for me.

(system info MySQL Workbench Community (GPL) for Linux/Unix version 6.2.3 revision 12312 build 2280 (64 bit) Configuration Directory: /home/arsen/.mysql/workbench Data Directory: /usr/share/mysql-workbench Cairo Version: 1.13.1 OS: Linux 3.13.0-76-generic CPU: 4x Intel(R) Core(TM)2 Quad CPU @ 2.40GHz (1596.000MHz) - 5,83GiB RAM Distribution: Ubuntu 14.04.3 LTS )

How do I enlarge an EER Diagram in MySQL Workbench?

7 Answers7

Linked