Import Database clone

Overview

After you have obtained a database dump, you can proceed and import it into the local instance of MySql Server.

Import

Please follow the steps below to perform the operation:

1. Ensure the dump file is not in an archived format, but as plain SQL - extract it if needed.

2. Open MySQL Workbench and in the Management tab, select Data Import/Restore

3. Choose Import from Self-Contained File and select the dump file

4. Create a new Database Schema as a target or mention an existing empty one

5. Click Start Import (the process might take a few moments).

Test

After a confirmation message is displayed, can perform a double check on the just imported database:

1. Go to the Schemas tab and hit Refresh button

2. Search in the available schemas and the new database should be present

3. Look for tables - all Mambu tables should be listed.