It is helpful to have a visual representation when designing a database. MySQL Workbench allows you to create entity relationship diagrams [ERDs] with relationships between the tables [one to one, one to many] and rearrange them as needed. Below we cover how to create an ERD from a downloaded SQL file.
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 image 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.
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.
How do I view a script in MySQL Workbench?
Show activity on this post..
Open MySQL Workbench [6.3 CE].
In "Navigator" select "Management".
Then select "Data Export" [Here select the table whose create script you wish to export].
In Drop down select "Dump Structure and Data".
Select checkbox "Include Create Schema".
How do I find the schema structure in MySQL Workbench?
To access the inspector, right-click a schema and select the Schema Inspector. Each tab lists topic-oriented information in categories, such as tables, indexes, and triggers.
How do I find MySQL schema details?
To show the schema, we can use the DESC command. This gives the description about the table structure.