How to Import a Database into MySQL Workbench

When working with databases, it's often necessary to import existing models or schemas from other sources. In this article, we'll explore how to do just that using MySQL Workbench and Vertabelo.

Once you have your model ready, you can use Vertabelo to organize the tables. The imported model is visible in the diagram area, with a window informing you that the import has finished. Alternatively, you can copy and paste the SQL script instead of uploading it from your computer.

To start, open MySQL Workbench and select Server -> Data Export from the menu at the top. Choose the schema to be exported (in our example, it's demo) and the objects to export (here, we've chosen all tables). Click Start Export at the bottom, and in Export Options, you can choose to export each table to a separate file or all selected objects into a single file.

Once you have your SQL script ready, you can import it into Vertabelo. To do this, open Vertabelo and click on the three-dot menu at the top of the screen. Choose From SQL and then Browse to select the file from your computer. Next, type the name of the model and choose the database engine. Click the Create button next to Physical data model.

Another way to import an existing database schema into Vertabelo is to use the Vertabelo Reverse Engineering Tool. This tool allows you to connect to a database and export the model data to an XML file. Later, you can import this XML file into Vertabelo.

In conclusion, importing a database into MySQL Workbench using Vertabelo is a straightforward process. By following these steps, you can easily work with existing databases in Vertabelo and organize your tables for better management.

Import database mysql workbench