MySQL Workbench - Rearranging Schema Diagram - Autolayout not working

mysql sql mysql-workbench er-diagrams
Muthu Ganapathy Nathan picture Muthu Ganapathy Nathan · Oct 12, 2013 · Viewed 9.5k times · Source

I am using MySQl Work-bench 2 to construct a schema diagram., by reverse engineering the database. However, when I included 450 tables., the tables are getting overlapped with one another and its practically impossible for me., to rearrange because there is no space.

The arrange option in Mysql work-bench is also not so helping. Is there any tool available in internet., which could also rearrange. Or I only have to do the divide and conquer method. i.e partially selecting part of the tables and constructing the diagram part by part.

Answer

Sairam Krish picture Sairam Krish · Oct 15, 2014

I am using Mysql Workbench 6.1. By default the diagram will look crunched for large number of tables, making it difficult to figure out relationship between tables. Many tables will overlay on other tables. This is because, the default layout size is small.

In the menu, Go to Model >> "Diagram properties and size".

Change width and size to some thing big (for example width 23 and height 5) - enter image description here

Then in the menu, Go to Arrange >> Autolayout.

Now we should see a clean diagram with all the relations. Now we can re-adjust width and height, more meaningfully

For MySQL workbench 8.0, we need to select Arrange > Align to Grid and Arrange > Center diagram contents and THEN Arrange > Autolayout - thanks to @mowwwalker for this info

Related questions

Error Code: 2013. Lost connection to MySQL server during query

I got the Error Code: 2013. Lost connection to MySQL server during query error when I tried to add an index to a table using MySQL Workbench. I noticed also that it appears whenever I run long query. Is there away …

Read More
MySQL Workbench: How to keep the connection alive

Error Code: 2013. Lost connection to MySQL server during query I am using MySQL Workbench. Also, I am running a batch of inserts, about 1000 lines total (Ex. INSERT INTO mytable SELECT * FROM mysource1; INSERT INTO mytable SELECT * FROM mysource2;...mysource3...mysource4 …

Read More
How to generate the whole database script in MySQL Workbench?

I want to take the whole database. Where do I find the database file? And is there a way to write the whole database with all data to a text file (like the one in SQL Server)?

Read More