Mysql Workbench Diagram To Sql

by

Create a Diagram from a SQL File

  • If using a database on your server, download the SQL file using cPanel Backup Wizard or phpMyAdmin.
  • Download MySQL Workbench for free at dev.mysql.com and install it on your local machine.
  • Open MySQL Workbench.
  • Select File and New Model from the top menu.
  • Select File, hover over Import, and press Reverse Engineer MySQL Create Script….
  • Specify the SQL file needing a diagram. Press Execute, Next, and then Finish.
  • At this point, you can rearrange and connect tables using the options on the left.
  • Once you’re done editing, you can export the diagram as PNG, SVG, PDF, or postscript file.
  • View the exported to check results.

    • To create a diagram for a database directly from cPanel, you’ll need to connect MySQL Remote Workbench to your server and ensure port 3306 is open.IC

    Need help? Ask a question, share a helpful tip, or help others in our community forum.

    Click the Properties tab of the panel on the lower left and then click one of the tables on the canvas. This action displays the properties of the table in the Properties window, as the next figure shows. While a table is selected, you can use the Properties window to change a tables properties. For example, entering #FF0000 for the color value will change the color accent to red.

    Changing the color of a table is a good way to identify a table quickly—something that becomes more important as the number of tables increases. Changing the color of a table is also an easy way to identify a table in the Model Navigator panel. This panel, the uppermost panel on the left side of the page, gives a birds eye view of the entire EER canvas.

    The EER Diagram canvas is where object modeling takes place. To add a table to the canvas, select the Catalog tab in the middle panel on the right side of the application to display any schemas that appear in the MySQL Model tab. Find the sakila schema and expand the view of its objects by clicking + to the left of the schema name. Expand the tables list in the same way.

    MySQL Workbench automatically discovers that address.city_id has been defined as a foreign key referencing the city.city_id field. Drop the country table onto the canvas and immediately you should see the relationship between the country table and the city table. (To view all the relationships in the sakila database, see Figure 9.35, “The sakila Database EER Diagram”.)

    1 Answer 1 Sorted by:

    Try: File->Export->Forward Engineer SQL CREATE Script

    Thanks for contributing an answer to Stack Overflow!

  • Please be sure to answer the question. Provide details and share your research!
  • Asking for help, clarification, or responding to other answers.
  • Making statements based on opinion; back them up with references or personal experience.

    • To learn more, see our tips on writing great answers. Draft saved Draft discarded

    FAQ

    How do I export a database from MySQL Workbench to SQL?

    To export diagram go to menu, select File, then Export, select one of the available formats and provide folder and filename. Here is my diagram: See it in other formats: Sample PDF export.

    How do I create a database diagram in MySQL Workbench?

    2 Answers
    1. Select the schema to export in the Tables to export.
    2. Click on Export to Self-Contained file.
    3. Check if Advanced Options… are exactly as you want the export.
    4. Click the button Start Export.

    How do I get SQL script from MySQL Workbench?

    To run SQL script in MySQL, use the MySQL workbench. First, you need to open MySQL workbench. Now, File -> Open SQL Script to open the SQL script. Note − Press OK button twice to connect with MySQL.