Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Question Moving Firboard databases to a neu Kunena

More
17 years 2 months ago #6212 by Oumie
Moving Firboard databases to a neu Kunena was created by Oumie
Hello,

I have a difficult problem.

I am now using fireboard on my site, but I'm moving my site. So what I want to do is install Kunena in my new joomla 1.5 and move al my data (users, messages and all) to the new website.

Can anybody tell me how I can do this??? I hope someone can help me.:(

Greetings

Please Log in or Create an account to join the conversation.

More
17 years 2 months ago - 17 years 2 months ago #6214 by core2
Replied by core2 on topic Re:Moving Firboard databases to a neu Kunena
Pleas be a title more explicit. Are you moving form one server to another? Are you using the same database? Assuming your current site runs Joomla 1.0 ?

I'm not aware of any J1.0 to J1.5 migrators for FBb/Kunena, correct me if I'm wrong!

assuming you migrate within the same server/db you can try something like this:

1. Take both site/forums offline.
2. Backup up your DB !!!
3. Upgrade your current 1.0 instalstion to kunena 1.0.8
4. Do a clean install of Kunena on your Joomla 1.5

5. modify the code below and put it on your server in a file called migrateKunena.php, outside the webroot.
6. Did i forget to mention: Backup your DB!!! DO IT!!!!
7. in a shell run: php migrateKunena.php
8. remove migrateKunena.php

Code:
<?php # Require lates version of Kunena on both sites. # Try to run it with the last MySQL_query commented out to test your DB connection. # DB prefix for your Joomla installs # The DB you want to migrate from $prefix10 = "mos" # The Db you want to migrate to $prefix15 = "jos15" # setting for your DB: $MySQL_Server = "xxx"; $MySQL_Database = "xxx"; $MySQL_User = "xxx"; $MySQL_Password = "x"; # connect to DB. $con1 = mysql_connect ($MySQL_Server, $MySQL_User, $MySQL_Password) or die ("Can't connect!"); mysql_select_db ($MySQL_Database) or die ("Can't open database!"); $SQL1 = "SHOW TABLES LIKE ". $prefix15 .'_fb%'; $que1 = MySQL_query($SQL1,$con1); echo("sql: $SQL1 que: $que1<BR>\n"); while ($r = mysql_fetch_array($que1)){ $table = $r[0]; $SQL2 = "REPLACE into $table SELECT * FROM " .str_replace($prefix15,$prefix10,$table); $que2 = MySQL_query($SQL2,$con1); echo("$SQL2 que: $que2 <BR>\n"); } mysql_close($con1); ?>

The script is provided without any guaranties.
There are probably better ways to do it... Messing on DB-level is always dangerous!!!
Visit the Kunena documantation .
Last edit: 17 years 2 months ago by core2.

Please Log in or Create an account to join the conversation.

More
17 years 2 months ago #6215 by wwwebguru
Replied by wwwebguru on topic Re:Moving Firboard databases to a neu Kunena
I just did this very thing with my site. It should be pretty simple if you have access to your Database.

1) I used phpMyAdmin and simply exported the tables with the prefix jos_fb_ from my old site database and saved it to a .sql file using the default options.
2) Then I accessed the new database and deleted all tables with the jos_fb_ prefix except these:

- jos_fb_config
- jos_fb_config_backup
- jos_fb_versions

**You won't have any jos_fb_ tables unless you've installed Kunena on the new site, so do this first if you haven't already.

3) Import the .sql file you exported from your old Database, again with all the default options.

That's it!! When I refreshed my Database I had all the posts from my old forum.
NOTE: One thing though...the users were in the new database from the old forum but once I sync'ed them with the new site they were removed! I didn't need the old users so I didn't mess with this.

Hope this helps!!

Please Log in or Create an account to join the conversation.

More
17 years 2 months ago #6653 by itgl72
Replied by itgl72 on topic Re:Moving Firboard databases to a neu Kunena
I need to make sure I don't lose users.

I'm researching myself now how to go about this.

I am working to get a website that is 1.0 using CB, JACL, UDDEIM, & FIREBOARD, over to a J1.5 website and do not want to lose USERS or FORUM posts.

Is this still the best and only way to go about this or is there a better way?

I'm an average joomla admin, but no pro at it.

Please Log in or Create an account to join the conversation.

More
17 years 2 months ago #6657 by core2
Replied by core2 on topic Re:Moving Firboard databases to a neu Kunena
Itgl72:
If you are planning to use the same web & database (db) server you must use different db prefix for your J1.0 and J1.5 install! In that case you will not use any of you users. But as always: BACKUP file and db !!!!

Have a look at mtwMigrator over at www.matware.com.ar/joomla/mtwmigrator-english.html . Is support Fireboard, so it may work for Kunena since they share table names?
Visit the Kunena documantation .

Please Log in or Create an account to join the conversation.

More
17 years 2 months ago - 17 years 2 months ago #6658 by itgl72
Replied by itgl72 on topic Re:Moving Firboard databases to a neu Kunena
core2 wrote:

Have a look at mtwMigrator over at www.matware.com.ar/joomla/mtwmigrator-english.html . Is support Fireboard, so it may work for Kunena since they share table names?


I looked at that product and it didn't make me feel comfortable in using it after reading the web page. Doesnt seem to be ready for the big show yet, its one of those, it might work, it might not work, but will I know exactly what didnt work?

THERE HAS GOT TO BE A BETTER WAY.
Last edit: 17 years 2 months ago by itgl72.

Please Log in or Create an account to join the conversation.

Time to create page: 0.222 seconds