| |"Alexander Rigo" <[EMAIL PROTECTED]> wrote: | |> Hi, |> |> what do i have to do to copy the staging-db completely into the |> live-db (once a week). I think repligard is not the right tool for |> that (tried it and there | |Repligard IS THE RIGHT tool for DB replication. | |> are still differences, maybe because of the fact that i use nadmin). | |What differences? |
Maybe it is because of the fact that i use nadmin studio, ans the problem is known that deleted items fomr the staging server are not clearly deletet from the live server. This is the reason why i do this: ## # 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 ## But there is still one problem left: the last step imports the pages and articles in SG0 and i had to fix this manually. Maybe there is a better way to do this, because it should work as a cronjob autonomously. Regards, Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
