How to Synchronize two database in MySQL or MariaDB by using Heidi SQL- MariaDB Admin / Dev Tutorial

How to Synchronize two database in MySQL or MariaDB by using Heidi SQL demo explains
How to synchronize two MySQL or MairaDB Databases by using Heidi SQL
What are different options available when synchronizing two databases such as Insert, Delete + Insert( Truncate first), No Data, Insert Ignore etc.
Different Items to consider before running the synchronizing the databases

Check out below link to follow step by step tutorial for MariaDB for beginner to Advance

This video can be used by people who want to get training as
MySQL Developer Tutorial
MySQL DBA Tutorial
MariaDB Tutorial / MariaDB Training free
MariaDB DBA Training step by step
Real time MySQL / MariaDB training

[ralphlinkus]

Thank for this tutorial. Please, how can I synchronize MySQL database on my local server connected to the internet to the Live/public server? Thanks

[dimitribervoets]

A lof of secenarios indeed; unfortunately the one I'm looking info for was not explained.
I think one of the simplest scenario's; in my case the most used: I install a new version of a database in database_new and want to only syncronize the structure to the database_production. So if there is a table missing, add it; if there is a field in a table missing, add it. Same if a table or column was deleted in database_new, delete it in database_production. Do not add or remove records.

When you select 'No data' in HeidiSQL and option to database, nothing seems to happen.


The sound quality of this video is so bad I couldbarely stand it, please improve it.


Thanks for trying to explain.