I read the Share authors table between two eFiction sites, but I'm not sure this is enough.
We are trying to combine two efiction sites into one. The main site is on 3.5.1, while I only know the other to be 3.5. Both sites have members, authors, and reviews, and we'd hate to lose any of them, but I am willing to go into each one and edit the database if I have to just to make it work. About 100 stories were uploaded manually, a number have reviews, which is why we would hate to have to do it all over. Both sites are small, so I don't think editing stuff will be impossible to make it work.
Any suggestions on how to go about this?
You'd have to very carefully plan it out and probably write a migration script. The problem is that the same #'s will exist in both databases. Assume site A will contain the user data and site B will bridge to it. For site B you will have to move all of the information in authors to the site A's database and assign new uid #s to the authors. Then you'll have to go back to site B and edit the tables to switch the old uid # to the new uid # in every table. Off the top of my head that would include authorprefs, stories, chapters, reviews, favorites, comments, etc. Anywhere where a user's information is attached to a piece of information you'll have to edit the uids. And you'll have to create some sort of map so you know that the new user in site A is # AAA and that matches to the existing member in site B with # BBB.
