MySQL Workbench is a GUI software for working with MySQL Databases, it offers a visible interface to carry out varied duties for information administration, and importing information from an exterior supply is a kind of duties. An exterior supply is usually a dump file, which is a plain textual content file that has SQL statements to recreate the construction and information of a database.
On this article, you’ll discover ways to import and dump information into MySQL Workbench. To start with this information, you will need to have MySQL Workbench put in in your system.
Import Dump Into MySQL Workbench
Launch MySQL Workbench, click on on “Database”, and choose the choice “Connect with Database”:
A brand new wizard will open, choose a neighborhood database that you simply wish to join, present a username, and host as “127.0.0.1” and click on on “OK”:
If you wish to connect with a Distant MySQL server then select that, present its endpoint in “Hostname”, the “Username,” and click on on “OK”:
Enter the password and click on on “OK”:
You’ll connect with your MySQL Server efficiently:
Choose the “Administration” tab from the aspect panel:
Choose the choice “Information Import/Restore”:
Or you possibly can choose it immediately by clicking on “Server” to open the listing and choose “Information Import”:
The information import wizard will open, choose the choice “Import from Dump Challenge Folder”:
After choosing the choice of importing information from Dump, browse for the dump mission folder and click on on “New”:
Present a reputation for Schema and click on on “OK”:
Choose the Schema and click on on “Begin Import”:
Wait till the method will get accomplished:
After the completion of import, Go to the Schemas tab and open an inventory by Proper clicking, select the choice “Refresh All”:
Watch for the Schemas to refresh and see if Schema is imported from the Dump file efficiently or not:
It’s seen within the output that information is efficiently imported from the Dump file into MySQL workbench.
Conclusion
By importing the dump into MySQL Workbench, you possibly can have entry to the entire information contained throughout the dump file. Merely connect with the Native or Distant MySQL database, open the “Server” listing, click on on “Import Information”, choose the choice “Import from Dump Challenge Folder” browse for dump mission, and click on on new, present the identify of schemas and choose the schemas to import. It should import dump into your MySQL workbench.
