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

Is this possible? If yes, how to do that?

Please use the Search feature of the forums, they will save a lot of time and effort.

This post might point you in the right direction.

The task of moving a forum, topics, messages, attachments and users, is not easy to describe within a forum context as we have here at www.kunena.org but there are a number of topics that describe the broad principles and issues that you should pay attention to.

There are several things that you need to consider when moving something as complex as Kunena from one Joomla website to another location:

1) The versions of Joomla used on the source and target site;
2) The versions of Kunena used on the source and target site;
3) The supporting software involved (e.g. Apache, MySQL, PHP, other extensions, etc.)
4) Is it really necessary to keep the old stuff? See I want to migrate my forum to Kunena ...

As a start, I suggest that you look at msgs #4 and #6 of Copying my forum from a J! 2.0 site to a J! 3.0 site and also msgs #4 and #6 of the topic [Merged topic] How to move my Kunena forum from one site to another . Even though these topics may relate to older versions of Joomla or Kunena the principles are basically the same.

The three things that you need to move from one site to another site are:

1. Kunena data (tables);
2. Joomla users; and
3. forum attachments

Literally, that's all you need to do but, as I mentioned earlier, the solution may be complicated if the new/target site runs a different mix of software to the original/source site.

Perhaps the easiest way to move a forum from one location to another location is to use a tool like AkeebaBackup, backup the whole of the original site and then restore the entire site on the new location and work through any remaining issues on the new location. The question asked by majdyk does not indicate whether the old site is hosted on a different platform to where the new site will run but, if you want a really quick solution, performing a backup/restore is the quickest solution of all.

G'day,
I am upgrading my site and I would like to know the best way of moving all the old forum posts to the new forum installation?

Can it only be done through phpMyAdmin (Or similar DB browser)?
If so; what tables do I need to export and under what settings?

Thanks

*** Topics merged ***

See my response in msg #3 above.

Thanks for the info... However I have just tried doing this and hit a snag.

It seems some of the table column names have been changed and new ones added...
I get this error;
Dumping data for table `sgj_kunena_categories` -- INSERT INTO `sgj_kunena_categories`
#1054 - Unknown column 'parent' in 'field list'

When I go an check, it is indeed correct.

How can we import when the DB structure has changed???