Saturday, May 12, 2018

How to restore/import dump file in MySQL workbench ?

The following steps can be applied to import dump file :

1. Open MySQL workbench and connect to database using your password. You can see the window as given below:


2. You will be provided two ways to import the dump files.
First, you can import the dump files by selecting the option "import from dump project folder". Here you can select the folder where all your dump files are stored. It will automatically import the files in database from which it was created if the database with the same name exists. So, it is better to create database with the same name and then start the importing process.
Second, you can select the option "import from self-contained file" which will allow you to add dump files one by one. In this option before starting import process, choose the default target schema as your database in which you want to import the dump files, from the drop down list.
 Then click on "start import" button. This will import your single dump files in the selected database. Similarly, you can repeat the process to import other files as well.


3. You are done with it. If you don't see the imported table in your selected schema then close and re-open the MySQL workbench.

0 comments:

Post a Comment