Contents [hide]
We will learn how to import database dump file from MySQL database using MySQL Workbench.
Note: Prerequisite MySQL database and MySQL Workbench already installed in your system.
Need to follow below steps for import database dump from MySQL database using MySQL workbench.
Step 1: Open MySQL Workbench. Create new MySQL Connections. If it is not available.
Step 2: Open MySQL Connections.
Step 3: Select Administration. Click Data Import/Restore. Select Import from Self-Contained File. Select SQL file. Click on the Open button.
Step 4: Click on New Button. Create Schema. Select Dump Structure and Data. Click on Start Import Button.
Step 5: Now you can see the dump file imported successfully.
