Sticky How to move, copy or merge my old Kunena forums from one site to another

I need to do the same thing but from a Joomla 1.6 site to a Joomla 1.7 site. Both sites are running K 1.6.5 I think it is. I don't really care if the users are associated with their posts. All I really care about is that all of the original posts not be lost in the move and show up on the new site.

From there, even if users don't associate with the posts, they can at least continue the thread as ongoing.

The Joomla 1.7 user database tables are:

jos_usergroups
jos_users
jos_user_profiles
jos_user_usergroup_map

and the collation is different for each database, i.e. jos_ could be jml_ or bbc_ or flb_ etc.

Jiminimonka wrote: the collation is different for each database ...

Minor correction to the terminology: the collation is the same (or it should be the same) but the table prefix name will probably be different in J! 1.7.

Is it the user tables that are the important tables in migrating Kunena? What I mean is, if the users are migrated already (keeping the same ID's) isn't it the Kunena tables that need to be migrated or is there some other relationship I'm not seeing here that makes the user tables relevant in this case?

That last part could be very likely.....

In my case, I would be most happy to simply keep the posts. There is no way the users would match up, plus, they aren't even the same users.

Does not matter to me if the users are properly associated with their posts, so long as folks can continue threads from the last post.

Is that at all possible?

karaokeamerica wrote: If the users are migrated already (keeping the same ID's) ...

Well, it depends on whether the users in one site are same as the users in the target site. Again, it all comes back to the definition of what you mean by "migrate". If migrate means move from A to B then there's no issue involved here about keeping user IDs the same, because they will be the same. But it migrate means merge whatever is in A with whatever is in B then it's a whole new ball-game.

You can't merge the users from A to B and keep the same IDs they were originally using before the merger took place; it's just not going to work. Likewise, if you ignore who owns which messages posted in forum A when you merge the messages into forum B then I don't know how you go about sorting out the mess.

Basically, you need to change all these ids (user ids, topic ids and post ids (and possible category ids, too) before you undertake the merger. This is not for the faint-of-heart or novice SQL player.