Skip to main content

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: d20e2a88-faa7-4336-97ba-1c524abb9088.png

  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.