Crawl with friendsĭefault diagram When the process ends with success you get a new model more about models here with default diagram with all tables and views. Reverse engineer a database To create a diagram from existing database you need to use reverse engineering functionality to create a model. See live HTML database documentaion sample. Here is a sample export of complete database documentation with diagrams. There is a better way to create and share diagrams for existing databases - Dataedo. To export diagram go to menu, select Filethen Exportselect one of the available formats and provide folder and filename. When your diagram is complete and safe it you can export it to pngpdfps or svg. Once you have completed your diagram make sure to save it. Coding and Implementing a Relational Database using MySQL To manually arrange tables simply select them and move around when you feel they fit best.
#Mysql workbench diagram from existing database manual#
Without a warning! To arrange tables you can try autoarrange option, but you'll need some manual work on top of that. To remove table from diagram select it, right click and choose Remove Figure option.īe careful not to choose Delete option as it will remove table not only form diagram but also your model catalog. What you probably want to do right after you created a default diagram is to remove unnecessary tables and views and arrange tables to make it easier to grasp. When the process ends with success you get a new model more about models here with default diagram with all tables and views. MySQL Tutorial: Creating an Entity-Relationship Diagram Wait for reverse engineering to take place and when done continue with Next.įinal screen shows you a summary of the import. On next screen you have an option to select object types and filter specific objects.
Wait for the schemas being read and continue with Next. Select the ones you want to reverse engineer. When successfully connected wizard will show you list of available schemas on the server. Wait for the connection and click Next again. To reverse engineer database go to menu Database and choose Reverse Engineer Provide connection details to your database and click Next. To create a diagram from existing database you need to use reverse engineering functionality to create a model.