This tutorial will help you understand the process of importing data into your MySQL database running on Windows and MacOS using MySQL Workbench.
It will also work on Linux; However, on Linux I would like you to use Commands, as it is faster and easy way to handle the import operations.
Open MySQL Workbench
Open Workbench and connect to your preferred database connection it can the local or the remote server. In my case for demonstration, I am using the local MySQL database
If you do not have the connection created already click on the Plus button to create new connection as showing below:
As soon entered the connection details make sure that given setting are correct, you can do that by clicking on the Test Connection button. It should show success message:
Open MySQL Connection in Workbench:
Click on your preferred connection to open the Instance it can be a local or the remote instance.
If you do not have the existing database, then you can create one using SQL query or by visiting the Schemas.
Import the Data from Exported SQL file or SQL project folder:
Next, from menus visit Server and Click on Data Import
You should see the Data Import Screen where you can select the File/Folder
- Click on the Import from Dump Project Folder or the Import from Self-contained File
- Browse & Select folder or file
- Select Target Schema/Database
- Click on the Import Progress Tab
As soon as you are on the Import Progress tab after configuring the import settings.
Now we are ready to start the import process, Click on Start Import button to start the process.
Congrats you have successfully imported the database from MySQL dump file into the database using MySQL workbench.