Question Moving kunena database tables

I have 2 very similar Joomla 3.4.1 installations, both with the same version of kunena forum installed. Instance 1 has 12 forum categories and instance 2 has those plus 34 others. I wish to move my kunena from instance 2 to instance 1, replacing it entirely so that both instances (of the forum, not joomla) are the same.

Using phpmyadmin I exported all <prefix>_kunena_* tables, changed the prefix to match that of instance 1, removed all kunena tables from instance 1 and then imported the instance 2 tables from the edited sql file.

After doing that the forum of instance 1 seems to work OK, no problems observed, EXCEPT it still only contains the same 12 categories rather than the 46 that instance 2 has. It's as tho I didn't import the tables at all!

But using phpmyadmin it's easy to see all 46 categories are there in the <prefix>_kunena_categories table. I thought by copying ALL kunena tables rather than only the _categories was the safer way to go. The two joomlas are using different databases.

Questions:
1) where is the flaw in the approach I took?
2) are there other non-kunena tables that need to be migrated?
3) why isn't the kunena data fully encapsulated in kunena tables if #2 is true?

Any help in migrating my kunena installation between the two joomla instances would be greatly appreciated.

Thank you!

---

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 128M | Max file upload: 200M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
159	Forum	kunenamenu	view=home&defaultmenu=161	forum	No
160	Index	kunenamenu	view=category&layout=list	forum/index	No
161	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent	No
162	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic	No
163	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies	No
164	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
165	Profile	kunenamenu	view=user	forum/profile	No
166	Help	kunenamenu	view=misc	forum/help	No
167	Search	kunenamenu	view=search	forum/search	No
168	Forum	mainmenu	Itemid=159	kunena-2014-12-31	Yes
175	Discussion Forum	mainmenu	view=category&layout=list&catid=0	discussion-forum	No

Joomla default template details : vg_progressive | author: Valentín García | version: 1.0.5 | creationdate: Unknown

Kunena default template details : Blue Eagle | author: Kunena Team | version: 3.0.7 | creationdate: 2015-02-01

Kunena version detailed: Kunena 3.0.7 | 2015-02-01 [ Galah ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	30
messages_per_page	10
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images
showchildcaticon	1
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	50
maxsig	300
regonly	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	75
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	120
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
sessiontimeout	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
defaultpage	recent
default_sort	asc
sef	1
showimgforguest	1
showfileforguest	1
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
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
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
iptracking	1
rss_feedburner_url
autolink	1
access_component	0
statslink_allowed	1
superadmin_userlist	0
ebay_language	0

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=0
Kunena - Kunena Enabled: avatar=1 profile=1
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (en-GB)

Third-party components: CommunityBuilder 2.0.7

Third-party SEF components: None

Plugins: None

Modules: None

1) try recount on the tools page.

2) Yes Users and usermap Should be also migrated. Because the userid. If the id's are the same, then you don't need it.

Perhaps I'm fooling myself?

In the admin section of jommla, I can see all of the categories just fine. I don't see them on the public site tho. Is there a limit in the configs on how many categories are displayed on the main forum index page?

If not, how do you explain the discrepancy between the backend categories and what is shown in the index?

There is only 1 user now, the admin user. IDs are the same for both instances.

I did the recount, no change, no errors.

You need to check permissions of categories if all are not changed after the move