Question Import Kunena forum data to other Kunena forum

Good information.

Could some one who has successfully migrated a Kunena form from a 1.5 site to a 1.7.x and upgraded the 1.7 site to 2.5.1 create a screencast of how they do this? Please post youtube link as reply.

I offer $10 for your time. Just le me know what e-mail address to send paypal money to.

Sorry, I'm afraid I don't have any screencasts to share on the procedure. However, I've successfully performed what you're asking about, and here is how I did it:

- I installed Kunena 1.7.2 over Kunena 1.5 using the standard Joomla extension installation procedure. This upgraded all the Kunena tables to the latest version

- then I installed JUpgrade on my Joomla site and used that to upgrade to Joomla 2.5.1

You can find more detailed instructions on upgrading your Joomla site to 2.5.1 in this document.

@sozzled Thank you! It's exactly what I started to do - I created new hosting account, copy the site, and after I improve my new site I will replace my old site with my new one.

@waptug - you asking about screenshots for kunena upgrade or joomla upgrade? In my joomla 1.5 site at this moment I have Kunena 1.7.2... I will try to upgrade my joomla site from 1.5.23 to 1.7.x to 2.5.1 If you need screenshots from this operation I can create they for you for free

Sorry for late reply, but I promised to make a little manual. It is also for Jomsocial, when you don't use that just skip the Jomsocial (jos_community) part.

Backup old site first. Use Akeeba, a great tool. The basic free version will do fine.

Also I would advise you to make a local test server with LAMP or TurnKey Linux. When you install this in a virtual PC you can go back anytime to an earlier snapshot in just a few seconds. I made a Linux installation in VMWare and installed VirtualMin (a multi server extension). In this I have 12 servers(!) running at the same time. You can easyly test and compare. Go back to a previous state is a matter of a few seconds with a snapshot. Afterwards export your site with Akeeba, upload to the live server, unpack and go.

Preporations:

1. Upgrade Kunena on the old 1.5 site to the latest version
2. Do a clean installation from Joomla 1.7/2.5 and install the latest version of Kunena and the same version of Jomsocial as on your old site.
3. Install JUpgrade on the 1.5 site. The manual you will find on their site.
4. Set parameters in JUpgrade, like 1.7/2.5 database field
5. Them migrate the site in the 1.5 admin panel to 1.7/2.5. Don't check, probable it will be messed up. We only use it for the database tables.

Migration Users and JomSocial:

1. Go to phpMyAdmin -> database of your live site
2. Select below tables and Export their structure and data by clicking on Export from bottom drop down menu:
J17_user_usergroup_map ; J17_user_profiles ; J17_users ; J17_usergroups

3. Open the SQL dump file and replace "J17_" prefix from all SQL statements to the prefix of your new website, e.g. "vupca_"
4. Go to your phpMyAdmin -> database of your new Joomla 1.7 website
5. Delete the following tables:
J17_user_usergroup_map ; J17_user_profiles ; J17_users ; J17_usergroups

6. Click on Import and use the SQL dump file to import users data into your new website's database
7. Now you have all users migrated to Joomla 1.7 by respecting their IDs and Group IDs etc. This is critical for your other components like JomSocial
8. Now similarly, export all jos_community_ tables from your Joomla 1.5 database (not the Joomla 1.7 upgraded tables which were created by JUpgrade). These are tables with data of your live site.
9. Replace prefix of your old Joomla 1.5 site e.g. "j15_" from all SQL statements using your favorite text editor to the prefix of your new Joomla 1.7 website e.g. "vupca_"
10. Delete all J17_community_ tables from your new website's database
11. Import the SQL file into the database of your new Joomla 1.7 website using phpMyAdmin -> Import option
12. Now you have all content of JomSocial and Users in your new site. Still you would not see images and thumbnails on JomSocial content because they are in file system of your old site and we haven't yet migrated that.
13. Now copy below folders from your Joomla 1.5 or 1.6 site to ROOT/images folder of your new Joomla 1.7 site
ROOT/images/videos ;
ROOT/images/photos ;
ROOT/images/originalphotos ;
ROOT/images/groupphotos ;
ROOT/images/avatar

14. Congratulations, Now you have a fully upgraded JomSocial from Joomla 1.5 or 1.6 to Joomla 1.7!

Migrate Kunena:

1. Go to phpMyAdmin -> database of your live site
2. Export all J17_ kunena tables from your Joomla 1.5 database.
3. Replace prefix from all SQL statements using your favorite text editor to the prefix of your new Joomla 1.7 website e.g. "vupca_"
4. Go to your phpMyAdmin -> database of your new Joomla 1.7 website
5. Delete all the J17_ kunena tables.
6. Click on Import and use the SQL dump file to import all data into your new website's database
7. Now copy below folder from your Joomla 1.5 or 1.6 site to the same folder of your new Joomla 1.7 site:
ROOT/media/kunena

8. Congratulations, Now you have a fully upgraded Kunena from Joomla 1.5 or 1.6 to Joomla 1.7!

This should work for Joomla 2.5 too, but I didn't tested that. Otherwise you go from 1.5 to 1.7, migrate and upgrade to 2.5.
Did you checked if your template is compatible too with 1.7/2.5?

Afterwards you can put back the backup you made from the 1.5 live site. In this way you keep a clean installation.

I hope you manage, good luck

@Plugje

Thank you for such a detailed manual!

but I will make mix - your suggestions + new site creation. My old site have a lot of extensions for j1.5 only, therefore I keep user details, kunena and other details, but I will create other site with jomsocial, kunena and other latest extensions and when after that I will replace my old site with new.

Glad I could help.

For migration from site to site you also can use this. It's even easier.

1. Export this tables from the old site:
jos_users ; Jos_core_acl_aro ; Jos_core_acl_groups_aro_map

2. Delete in the new site the same tables.
3. Import the exported tables into the new site

Jomsocial

1. Export all the jos_community* tables from the old site:
2. Delete in the new site the same tables.
3. Import the exported tables into the new site
4. Copy the following folders from the old site to the new site:
/images/avatar ; /images/groupphotos ; /images/origionalphotos ; /images/origionalvideos ; /images/photos ; /images/videos

Do the same with all the kunena tables.

Be sure you have the same versions on both sites, otherwise first update to a newer version. Also sometimes extensions have some problems with the database. In that case, just import all the tables and run again an installation of Kunena and Jomsocial. Your settings will not be overwritten, but sometimes new data entries will be made.

Older extensions can be a problem yes. There are some extension to make your own modules/plugins. I want to try one of these days if I can update an older version with this. It may be possible to make an empty module, copy the php, scripts etc in this module. Hopefully it will work then in a newer version. But...it just an idea..if it will work...time will tell