URGENT: simple quick script to synchronize several mysql tables

  • 状态: Closed
  • 奖金: $10
  • 参赛作品已收到: 1
  • 获胜者: brnopcman

竞赛简介

I need this URGENTLY to help debug and fix a problem I'm having.

I need a simple script which will do the following (pseudo-code):

READ from configuration file, the host, port, user, password of two mysql servers: SERVER1 and SERVER2.
For each DATABASE in SERVER1, repeat:
For each TABLENAME in [login to view URL], repeat:
Let T1 represent TABLENAME in [login to view URL] and T2 represent TABLENAME in SERVER2.DATABASE.
Get the name of the auto_increment primary key column of T1 (if none defined, skip to next table).
Select the MAX(primary key "PK" value) from T1 and T2
For each ROW in T1 that has a PK value larger than MAX([login to view URL]), copy the row from T1 to T2.
Compare the COUNT(*) from T1 and T2, and if they don't match, print a warning.
Done
Done
; end of pseudo-code

In the public phase of the contest, please upload screen shots showing your test procedure and test results. The code will be uploaded only if you are selected as the winner. THE CONTEST MAY BE ENDED EARLY IF A SATISFACTORY SUBMISSION IS RECEIVED.

您还可能感兴趣的技能

此竞赛的顶尖作品

查看更多参赛作品

公共说明面板

  • minhanoi
    minhanoi
    • 5 年 之前

    Do you accept NodeJS script?

    • 5 年 之前

如何以竞赛开始

  • 发布您的竞赛

    发起您的竞赛 快速简单

  • 获取众多参赛作品

    获取大量参赛作品 来自世界各地

  • 悬赏最佳参赛作品

    悬赏最佳参赛作品 下载文件-简单!

立即发布竞赛 或者立即加入我们!