Hi,
i want to discuss
the way i've solved my problem with two different databases in nadmin studio.
The problem was that deleted articles and pages are not replicated correctly. So
the solution for me is:
##
# to
prepare everything in the staging-db to export
mysql midgardstaging -e "update repligard set
changed=NULL"
#
export everything from the staging-db
repligard -c repligard_hourly_dump.conf -e
mydump.xmlgz
#
clear some relevant tables
mysql
midgardlive -e "delete * from article"
mysql
midgardlive -e "delete * from
element"
mysql
midgardlive -e "delete * from
page"
mysql
midgardlive -e "delete * from
record_extension"
mysql
midgardlive -e "delete * from
topic"
mysql
midgardlive -e "delete * from
blobs"
# import from the
staging-DB
repligard -c
repligard_hourly_import_live.conf -i
mydump.xmlgz
##
As far as i can say it
works. But i'm not deep enough into the database structure of nadmin/midgard to
say that the way i described is entirely right.Maybe some as a comment or a
better way?
Regards,
Alex
