Performing DB Schema Backup

STEP 1: Open MySQL workbench.

[ TAKE BACK UP OF ‘ivms_30.sql’ SCHEMA]

STEP 2: Go to Management and click on “Data Import/Restore” (as highlighted)

STEP 3: Select the “Import from Self-Contained File” (encircled in red). Then select the SQL/Dump file to import. 

                Kindly note that the whole file must be imported.

STEP 4: And then click on “Start Import”.

STEP 5: Go to “Management” and click on “Data Export”.

STEP 6: Tick mark “ivms_30” (as shown below) and then “Export it to Self-Contained file”, “Include Create Schema” and all selected database objects will be exported into a single, self-contained file.

STEP 7: Click on “Start Export”

STEP 8: Refresh the Schema view from the bottom left corner and check from the drop down if the tables are there as marked below.

After refresh you should see the table structure along with Stored Procedure from the drop down.