- 29 Oct 2021
- 1 Minute To Read
- Print
- DarkLight
- PDF
Import Database clone
- Updated On 29 Oct 2021
- 1 Minute To Read
- Print
- DarkLight
- PDF
To import a database into a local MySql Server, ensure the dump file is in plain SQL format. In MySQL Workbench, go to Data Import/Restore, choose Import from Self Contained File, select the dump file, and create a new Database Schema. Click Start Import and verify the import by refreshing the Schemas tab to see the new database and its tables, including Mambu tables.
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:
Ensure the dump file is not in an archived format, but as plain SQL - extract it if needed.
Open MySQL Workbench and in the Management tab, select Data Import/Restore
Choose Import from Self-Contained File and select the dump file
Create a new Database Schema as a target or mention an existing empty one
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:
Go to the Schemas tab and hit Refresh button
Search in the available schemas and the new database should be present
Look for tables - all Mambu tables should be listed.