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

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Disabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 3000 seconds | Max execution memory: 512M | Max file upload: 200M

Joomla default template details : rt_dominion_j15 | author: RocketTheme | version: 1.5.11 | creationdate: December 8, 2010

Kunena default template details : Evolution Dark Red K1.6 Template | author: TemplateKunena Team | version: 1.6.2 | creationdate: 2011-01-23

Kunena version detailled: Installed version: 1.6.3 | Build: 4344 | Version name: Parlare | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	LeadoverLove Forum
board_offline	0
board_ofset	0.00
offline_message	<h2>The Forum is currently offline for maintenance.</h2> <div>Check back soon!</div>
enablerss	1
enablepdf	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	0
disemoticons	0
template	Evolution-dark-red
showannouncement	1
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	100
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	150
allowfileupload	0
allowfileregupload	1
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
avatar_src	fb
fb_profile	fb
pm_component	no
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_username	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	1
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	1
rules_infb	1
rules_cid	96
help_infb	1
help_cid	99
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
fbsessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	6
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	100
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	auto
integration_login	auto
integration_avatar	communitybuilder
integration_profile	communitybuilder
integration_private	auto
integration_activity	auto
boxghostmessage	0
userdeletetmessage	1
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	image
listcat_show_moderators	1
lightbox	1
activity_limit	0
show_list_time	8760
show_session_type	0
show_session_starttime	0
userlist_allowed	0

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Installed (Version : 1.4) | Jomsocial: Disabled or not installed | UddeIm: Disabled or not installed

Third-party SEF components: sh404sef: Disabled or not installed | ARTIO JoomSEF: Disabled or not installed | AceSEF: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Enabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed | My Kunena Forum Posts: Disabled or not installed

Modules: Kunena Latest: Disabled or not installed | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed

Yes, it's fairly easy.

1. Goto PhpMyAdmin.
2. Goto your database where kunena is.
3. Click 'Export' on the top tab.
4. Select 'Custom - display all possible options.'

Tables:

1. Find and highlight all %prefix%_kunena_ tables.

Leave all other settings as default and export.

---

Now, install Kunena on your new website. After it's completely installed go into PhpMyAdmin of the new site and get ready to import----

Before that, however... You need to drop all the kunena tables on your new site. So goto the new database and in the 'Structure' tab, check box all of the %prefix%_kunena tables, goto the bottom where it reads "With Selected" (in a drop down menu), select Drop.

Finally, if the joomla %prefix% of your old site matches the one at your new site, you're in the clear to import and be finished.

If the prefixs are not the same from the old site, Open the file you saved in Notepad (it will be a *.sql file).

Now goto Edit > Replace. Type in your old prefix and replace all with your new prefix. (Example: 'joomla_' with 'joomla2_')

Final considerations:
I wouldn't import %prefix%_kunena_users if your users profiles are handled by community builder. It may cause minor de-sync issues.

The issue on only importing Kunena tables is that the users are not the same in the old and new site -> posts have wrong user bound to them. So you really need to import also users from Joomla.

De-sync issues are not going away by ignoring kunena_users table. User are and will be wrong unless you also import users OR create a complicated script to make sure that they do not conflict.

I need to transfer Kunena Data from: www.haushueter-forum.info to www.haushueter-plus.de .

From: Joomla 1.5.23; Kunena 1.7
to: Joomla 1.7.3 ; Kunena 1.7

I have allready transfered the data successfully however the post´s do not show up.

Can someone please let me know what type of data exactly i need to transfer and what else I should consitter to get the posts show up.
Thank you in advance

Peter

G'day, d0npedr0, and welcome to Kunena.

I suggest that you read the whole of this topic to understand what you need to copy and why there are complications when you move from J! 1.5 to J! 1.7 where two sites are involved. This is exactly the kind of problem that, unless you really know what you're doing and you know your way around SQL databases, I would pay someone else to do the work for me. Message #4 in this topic explains, exactly, the information that you need to move across.

Good luck.

sozzled wrote: G'day, d0npedr0, and welcome to Kunena.

I suggest that you read the whole of this topic to understand what you need to copy and why there are complications when you move from J! 1.5 to J! 1.7 where two sites are involved. This is exactly the kind of problem that, unless you really know what you're doing and you know your way around SQL databases, I would pay someone else to do the work for me. Message #4 in this topic explains, exactly, the information that you need to move across.

Good luck.

If someone wanted to follow your suggestion of paying someone.....who would they pay? Does someone offer a service of doing this?

www.joomlancers.com is one service. I can put you in touch with other services if you would like to PM me. I don't know the cost but I would imagine that we're talking USD 50-100 per hour.

Hi

I have Joomla 1.7 installed and after using various components on 1.5 I have found many do not work on 1.7.

How can i take my kunena forum from J1.7 to a J1.5 installation

cheers

Hello,

What exact kunena version are-you using actually ?

latest 1.7 kunena