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

I am currently running a Joomla site with Kunena. Everything is up to date. But I am still trying to resolve the issue of missing similes and users not been able to insert images to posts using the image tags.

So I have created a fresh install of Joomla and Kunena. My question is how do I import all the old posts, users, categories etc from my current Kunena installation to this new installation?

I have tried deleting the kunena tables in the new DB and inserting the older ones but, this isn't working.


This is still an attempt to solve my previous problem, so I don't know why that topic was locked?

Hello,

Copy the old kunena tables, with joomla users tables into new Joomla! installation site and then launch the installtion on Kunena 2.0.2.

anfieldred wrote: This is still an attempt to solve my previous problem, so I don't know why that topic was locked?

I locked the other topic because you wrote, I am going to start all over again. If this new site is an attempt to resolve other issues I have one simple question: Does this new site work? I mean, does the new site work without copying data from another site? Does this new site allow you to see things that you cannot see on your other site? That is my question.

If your new site does not allow you to see smilies or not let you insert images then it doesn't matter about how to copy all the other data, does it? So can we get the answer to the original question, please? Does this new website work? Yes or no? After that we can then talk about how to copy user tables and Kunena tables and attachment directories and files and all the other things that will take you the next four or five hours to do.

anfieldred wrote: How do I import all the old posts, users, categories etc from my current Kunena installation to this [a new] installation?

---

Moving a Kunena forum from one site to another is relatively easy (if you're not interested in keeping any existing data on the target).

There are 24 database tables in a "no-frills" Kunena installation which are:

xxx_kunena_announcement
xxx_kunena_attachments
xxx_kunena_attachments_bak
xxx_kunena_categories
xxx_kunena_config
xxx_kunena_config_backup
xxx_kunena_favorites
xxx_kunena_groups
xxx_kunena_messages
xxx_kunena_messages_text
xxx_kunena_moderation
xxx_kunena_polls
xxx_kunena_polls_options
xxx_kunena_polls_users
xxx_kunena_ranks
xxx_kunena_sessions
xxx_kunena_smileys
xxx_kunena_subscriptions
xxx_kunena_subscriptions_categories
xxx_kunena_thankyou
xxx_kunena_users
xxx_kunena_users_banned
xxx_kunena_version
xxx_kunena_whoisonline

And, in addition to those, there are several other tables that hold Joomla user information, depending on what version of Joomla we are discussing.

• In J! 1.5 there were some 7 tables:
  
  xxx_core_acl_aro
  xxx_core_acl_aro_groups
  xxx_core_acl_aro_map
  xxx_core_acl_aro_sections
  xxx_core_acl_groups_aro_map
  xxx_session
  xxx_users


• In J! 2.5 there are some 6 tables:
  
  xxx_session
  xxx_usergroups
  xxx_users
  xxx_user_notes
  xxx_user_profiles
  xxx_user_usergroup_map

As well as these things there are also the attachments that correspond to the messages. These attachments are stored in ../media/kunena/attachments.

There may be mistakes or things that I have left out. If someone else wants to correct any mistakes or omissions that I made, please feel free to contribute to this discussion.

sozzled wrote:

anfieldred wrote: This is still an attempt to solve my previous problem, so I don't know why that topic was locked?

I locked the other topic because you wrote, I am going to start all over again. If this new site is an attempt to resolve other issues I have one simple question: Does this new site work? I mean, does the new site work without copying data from another site? Does this new site allow you to see things that you cannot see on your other site? That is my question.

If your new site does not allow you to see smilies or not let you insert images then it doesn't matter about how to copy all the other data, does it? So can we get the answer to the original question, please? Does this new website work? Yes or no? After that we can then talk about how to copy user tables and Kunena tables and attachment directories and files and all the other things that will take you the next four or five hours to do.

Yes it works flawlessly.

sozzled wrote:

anfieldred wrote: How do I import all the old posts, users, categories etc from my current Kunena installation to this [a new] installation?

---

Moving a Kunena forum from one site to another is relatively easy (if you're not interested in keeping any existing data on the target).

There are 24 database tables in a "no-frills" Kunena installation which are:

xxx_kunena_announcement
xxx_kunena_attachments
xxx_kunena_attachments_bak
xxx_kunena_categories
xxx_kunena_config
xxx_kunena_config_backup
xxx_kunena_favorites
xxx_kunena_groups
xxx_kunena_messages
xxx_kunena_messages_text
xxx_kunena_moderation
xxx_kunena_polls
xxx_kunena_polls_options
xxx_kunena_polls_users
xxx_kunena_ranks
xxx_kunena_sessions
xxx_kunena_smileys
xxx_kunena_subscriptions
xxx_kunena_subscriptions_categories
xxx_kunena_thankyou
xxx_kunena_users
xxx_kunena_users_banned
xxx_kunena_version
xxx_kunena_whoisonline

And, in addition to those, there are several other tables that hold Joomla user information, depending on what version of Joomla we are discussing.

• In J! 1.5 there were some 7 tables:
  
  xxx_core_acl_aro
  xxx_core_acl_aro_groups
  xxx_core_acl_aro_map
  xxx_core_acl_aro_sections
  xxx_core_acl_groups_aro_map
  xxx_session
  xxx_users


• In J! 2.5 there are some 6 tables:
  
  xxx_session
  xxx_usergroups
  xxx_users
  xxx_user_notes
  xxx_user_profiles
  xxx_user_usergroup_map

As well as these things there are also the attachments that correspond to the messages. These attachments are stored in ../media/kunena/attachments.

There may be mistakes or things that I have left out. If someone else wants to correct any mistakes or omissions that I made, please feel free to contribute to this discussion.

Thank you very much, everything appears to be working at this stage.