How to synchronize two databases by using MySQL Workbench - MySQL Tutorial

Hi,
In this video we will learn how to Synchronize MySql tables structure, stored procedures & functions using MySql Workbench. [Method-1]

Scenario : we want to add new features to our project, so we need to update our db, we develop & test it in a local machine which includes addition & alteration of some tables, stored procedures & functions in localDb & now we want to deploy it in production. Before that we should know what are the changes made by us in localDb . so we will synchronize and find the difference and update our productionDb. Below are the steps to follow

2:23 : STEP-1: Export productionDb from live server (Structure only)
Note: This is required to Synchronize localDb and productionDb on local machine , as it is not advisable to Synchronize and update productionDb directly on live server. As errors may occur during updation. So we will check the synchronization of localDb and productionDb in the workbench. If it is executed without any error then we will use that script to update in the live server.

4:39 : STEP-2:Make a duplicate copy of exported productionDb file.
Note: We will use this file to import into the workbench. As we will make changes to this file before importing it to the workbench. So we should have an original copy of our exported productionDb, as we all know exporting may take time depending on database size.

4:55 : STEP-3: Remove definer
Note: We are removing the definer as we want to synchronize stored procedures and functions locally.

5:49 : STEP-4: Import into workbench
Note: Import modified productionDb into workbench, select dump structure only.

7:14 : STEP-5: Synchronize two database using "Synchronize with any source"

13:35 : STEP-6: update live server

[Method-2] Synchronize two database using "Synchronize with Model"
https://youtu.be/zZgqidlMxwY

? Leave your comments and doubts in the comment section
? Save this channel and video for watch later
? Like this video to show your support and love ❤️

***********
? BE MY FRIEND
? Check Out My Blogs: https://codepracticing.in/
? Add me on : https://www.instagram.com/codepracticing/
? Get in touch : [email protected]

#Synchronize #MySql #Workbench