Upgrading the production site
davidjava - January 3, 2008 - 20:56
I am running two sites in separate servers:
- the testing site
- the production site
as recommended in the good practices section.
While I am adding new content to the testing site, the internet users keep adding content to the production site at the same exact time. The problem arises when it is time to merge the two databases. There are rows in the two node tables which are showing the same identifier (nid column)! That makes impossible to merge the rows in a straighforward way.
Has anyone developed the appropiate SQL scripts to achieve that?
Best regards
I have created script mergedb.php
Hello,
Finally, I decided to develop the script myself. Please give it a try and tell me your comments. I executed it against my personal web site for several times and it seems to be running fine.
http://www.geocities.com/mergedb
I would have preferred to upload the material at the drupal site, but the CVS administrator cannot find the right section. It is not a module, it is not a php snippet, it is not a sql snippet, ... what is it? :(
When anyone should eventually detect a bug, I will try to fix ASAP and place a new package for download.
Regards.
Thanks for sharing it
Thanks for sharing it david.
sina.salek.ws
Feel freedom with open source softwares
Duplicated efforts
You should also read these recent threads:
http://drupal.org/node/232151
http://drupal.org/node/120617
It is very disappointing when several developers make efforts working on the same issue... I hope we can "merge" our ideas into a great common project.