Home arrow Forum Joomla smf db intergration
  Welcome, Guest. Please login or register.
Did you miss your activation email?
November 22, 2008, 04:08:38 PM
Home New Posts Search Calendar


Login with username, password and session length
+  Joomla Forum
|-+  Joomla Hacks
| |-+  Joomla-SMF Forum Support
| | |-+  Joomla-SMF 1.1.x (Moderators: -Wolverine, kai920)
| | | |-+  Joomla smf db intergration
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: Joomla smf db intergration  (Read 931 times)
Andrew Baxter
Joomla Newbie
*

Karma: +0/-0
Offline Offline

Posts: 1


View Profile
Joomla smf db intergration
« on: April 04, 2007, 02:50:20 PM »

hi I have been following instructions on installing joomla smf bridge ok so far smf and joomla in seperate databases but can't find out how to import smf tables into joomla database any help please or where can i go for instruction or tutorial. Cry
Logged
pcjunkie
Joomla Newbie
*

Karma: +2/-0
Offline Offline

Posts: 28


View Profile
Re: Joomla smf db intergration
« Reply #1 on: April 24, 2007, 10:21:31 AM »

Ok make a back up of both.

Then
part 1
go to your SMF DB and select export.

Select all
Select save Structure. uncheck any under that.
Select save Data uncheck any under that.

Now export as a gzip. SQL cannot import ZIP or raw Text in one hit, only Gzip.

So that brings us to import into Joomla.

Open Joomla DB select Import.

You should have no problems..

Part 2 Managing users.

In mySQL: select the user for SMF and save it to the Joomla Account by using [ADD USER]. now Joomla DB should have both as access right enabled.

Part 3

Get you SMF config file (settings.php) and change the DB name to Joomla.

e.g
Code:
$db_server = 'localhost';
$db_name = 'smf44980_smf_1';
$db_user = 'smf44980_smf_1';
$db_passwd = 'XNIDY683DD';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;
to

Code:
$db_server = 'localhost';
$db_name = 'joom4980_joom1';<<<<<<<<<<<<
$db_user = 'smf44980_smf_1';
$db_passwd = 'XNIDY683DD';
$db_prefix = 'smf_';
$db_persist = 0;
$db_error_send = 1;

You should now have smf and Joomla in one table... Wink
« Last Edit: April 24, 2007, 10:26:08 AM by pcjunkie » Logged
Pages: [1] Go Up Print 
« previous next »
Jump to:  



Login with username, password and session length

Powered by MySQL Powered by PHP Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com
Valid XHTML 1.0! Valid CSS!

Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved.
Terms of Use
Joomla Hacks



Joomla Hacks
German Lang French Lang Italian Lang Spanish Lang Japanese Lang Chinese Lang
MamboBuzz.com
Search Contact About Advertise Blogs Topsites Submit News Register Login