# <!-- METAHEADER
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"*": "https://raw.githubusercontent.com/wefindx/schema/master/method/oo-item.yaml"
# <!-- HEADER
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"base:title": "0oo - Automated dump and import"
"og:title": "Automated dump and import"
"og:description": "select * from table where version &gt; lastUpdate This would get all the records that have been updated since t he last update. We could then import this data. I don&#x27;t know what to do about data that already exists, we would have to generate update record sql commands. Whenever data is changed, update the lastUpdate field so that the next dump will cover that row."
"og:image": "https://avatars0.githubusercontent.com/u/28134655"
"og:url": "/method/19001/"
"base:css": "/static/css/bootstrap.min.9c25540d6272.css"
"base:extra-css": "/static/css/base.57997aeac1df.css"
"base:favicon": "/static/favicon.acaa334f0136.ico"
"base:body_class": ""
"layout:logo": "/static/0oo.8d2a8bbef612.svg"
"layout:index": "/"
"layout:menu": "/menu/"
"layout:categories": "/intents/"
"layout:ideas": "/methods/"
"layout:projects": "/projects/"
"layout:users": "/users/"
"layout:about": "/about/"
"layout:help": "/help/"
"layout:bug_report": "https://github.com/wefindx/0oo"
"layout:login": "/accounts/login/"
"layout:light-off": "/darken/?darken=true"
"layout:set-multilingual": "/mulang/?mulang=true"
"layout:lang": "语言"
"layout:set-language-post-action": "/i18n/setlang/"
"layout:csrf-token": "hYNcWR0InxJnIkfWWqNHSaCuBiiEpem6n96nE6OlGrQBXBn4CUdsPiKl9kRzGvkW"
"layout:input-next": "/method/19001/"
"layout:languages": [{"code": "ja", "is-active": "false", "name": "日本語"}, {"code": "lt", "is-active": "false", "name": "Lietuviškai"}, {"code": "zh-hans", "is-active": "true", "name": "简体中文"}, {"code": "en", "is-active": "false", "name": "English"}, {"code": "ru", "is-active": "false", "name": "Русский"}, {"code": "oo", "is-active": "false", "name": "O;o,"}]
# <!-- TOPIC
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"item:parent:intents": [{"url": "/intent/20001/", "title": "Multimaster replication"}]
"item:title": "Automated dump and import"
"item:summary": "We can run a query in each table to dump data that is newer than the last date we checked"
"item:voting": +1
"item:voting:add": "/admin/hlog/voting/add/?method=19001"
"item:voting:csrf_token": "hYNcWR0InxJnIkfWWqNHSaCuBiiEpem6n96nE6OlGrQBXBn4CUdsPiKl9kRzGvkW"
"item:voting:submit-value-option": {"selected": "[-]", "value": "-"}
"item:base-administration": false
"item:body": |
    select * from table where version > lastUpdate
    
    This would get all the records that have been updated since t he last update.
    
    We could then import this data.
    
    I don't know what to do about data that already exists, we would have to generate update record sql commands.
    
    Whenever data is changed, update the lastUpdate field so that the next dump will cover that row.
"item:source-date": ""
"item:permalink": "/method/19001/?l=cn"
"item:owner": "chronological"
"item:created": "2021-05-03T20:16:33.531801"
"item:ownerlink": "/user/198/chronological"
# <!-- LINKS
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"item:link:add": "/admin/hlog/link/add/?parent=19001"
"item:link:items":
"item:project:items":

# <!-- COMMENTS
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"item:comment:items":
- "id": "a-26001"
  "mtrans": |

    多主复制的复杂性不仅仅在于查找其他副本站点中的新增功能。我们可以使在一个节点上创建的数据只能通过与该节点进行交互来进行编辑，但是所有由每个节点创建的数据都将复制到所有其他节点。

  "text": |
    The complexity of Multi-Master replication does not stop at looking up what's been new in other replica sites. We could make the data that was created on one node only editable via interacting with that node, but all created by every node replicated to all other nodes.
  "owner": "Mindey"
  "ownerlink": "/user/147/Mindey"
  "permalink": "/method/19001/?l=cn#a-26001"
  "created": "2021-05-04T20:37:04.611724"
"base:js": "/static/js/base.c7357c06cc89.js"