Article 6DNXJ DB Sync Synergy

DB Sync Synergy

by
TBotNik
from LinuxQuestions.org on (#6DNXJ)
All,

I found some code that is supposed to sync databases, which I posted on the AD free pastebin at:
Quote:
https://controlc.com/5b2dbe99
But in finding it I found these problems:
  1. It only works for development to online production,
  2. It assumes the local DEV DB is the only one with changes,
  3. It therefore does not actually sync but deletes & replaces the online DB,
  4. It is not modular in design.
I found though it was a good starting point, so started editing it to add:
  1. Sync Local DB1 to Local DB2,
  2. Sync local DB table1 to Table2,
  3. Sync local dev to local test,
Since I'm just learning how to use MySQL and other DBs in Bash thinking that a collaboration to make this a full service DB sync routine would be great. I hope you agree and I want to start by changing to modular design, adding all processing into subroutine "FUNCTIONS", so the main processing can have a very fluid flow and from it call the processing functions that are needed.

Cheers!

TBNK
External Content
Source RSS or Atom Feed
Feed Location https://feeds.feedburner.com/linuxquestions/latest
Feed Title LinuxQuestions.org
Feed Link https://www.linuxquestions.org/questions/
Reply 0 comments