Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Yeshai Bouskila on August 24, 2008, 04:08:51 AM

Title: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: Yeshai Bouskila on August 24, 2008, 04:08:51 AM
Hi All,

I have a odd question here.
I have a SMF + TP support site in Hebrew, now a lot of my users want to move to SMF 2.0 although it's in Beta.
I want to use one DB for both sites in SMF 1.1.5 and 2.0 so they are in sync so all messages will appear on both sites.
Are there any DB changes from smf 1.1.5 and 2.0? is this something i can do that will not risk my DB structure?

Thanks for the help

Yeshai
Title: Re: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: Nathaniel on August 24, 2008, 04:14:54 AM
Short answer: No.

Long Answer: ;)
There are major database changes between SMF 1.1.5 and SMF 2 Beta. So you will not be able to use the same database for two separate versions of SMF at the same time, under any circumstances. Tiny Portal doesn't work for SMF 2 Beta yet anyway, so you should probably wait until SMF 2 reaches the stage where its more widely supported by languages, themes and mods such as Tiny Portal.

If you want to upgrade then there is documentation for it below - Remember that you will have to reconfigure your mods/themes and etc.
Upgrade SMF (http://docs.simplemachines.org/index.php?board=3.0;sort=subject)
Title: Re: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: Yeshai Bouskila on August 24, 2008, 04:20:44 AM
Thank you for the quick answer,
I know TP is not supported on SMF 2.0 just wanted to know if I can have both sites on one DB when smf 2.0 will not have TP on it only SMF

Thanks for the help
Title: Can I run two different sites with SMF 1.1.5 with one DB
Post by: Yeshai Bouskila on August 24, 2008, 02:02:38 PM
I was asking about smf 2.0 on 1.1.5 using the same db but that won't fly.

Here is the deal,
I want to run two sites one with SMF 1.1.5 with TP and another one with SMF 1.1.5 and wordpress.
The thing is I want to know if I can set both forum installs to the same DB with no risks?

Thank
Yeshai
Title: Re: Can I run two different sites with SMF 1.1.5 with one DB
Post by: greyknight17 on August 24, 2008, 02:32:04 PM
It depends what you mean by no risk. You should be able to have them sharing the same database. It's just that when one forum makes a change, it will be reflected to the other as well. I recommend running this on a test environment first to make sure that there are no negative side effects from this.

Otherwise, you might want to try looking at this topic (http://www.simplemachines.org/community/index.php?topic=16190.0) and use the idea there instead.
Title: Re: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: thefley on August 25, 2008, 12:14:22 PM
ok I was wondering the same thing...  I got the answer is NO

BUT

the problem I have is I am trying to set up another fourm with 2.0  (and keep the 1.1.5 going) but the problem I have is the host godaddy.com will not allow 2 data bases with the same name even on diff accounts.    I am trying to set up the 2.0 and import the old data base to get it set up and bring over all my data to look like the old board...

anyone direct me in the right direction? will I just have to use another DB name and then change something in the forum server settings admin page? 

thx
Title: Re: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: Deprecated on August 25, 2008, 01:34:17 PM
I had the same problem. I don't get to assign DB names, it's done by the host.

I unzipped my database backup, opened it in a text editor and changed the name. I forget the details but it was obvious at the time. I'm sure it will be obvious to you too when you open the file. The line you need to change is right near the top, only a few lines down.

Once you do that you should be able to upload the backup to your server's DB.
Title: Re: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: Yeshai Bouskila on August 25, 2008, 01:58:27 PM
Well i'm not looking to have two DB's but have two sites on the same server use the same DB
Title: Re: Can I run two different sites with SMF 1.1.5 with one DB
Post by: Yeshai Bouskila on August 25, 2008, 01:59:11 PM
Will do, thanks for the update
Title: Re: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: H on August 25, 2008, 02:35:59 PM
Topics merged.

You can share a database between SMF installs of the same version however it is possible you can run into problems if one installs mods which modifies the database.

Running different versions of SMF from the same set of DB tables won't work :)
Title: Re: Useing smf 2.0 and smf 1.1.5 with one DB so both sites are in SYNC
Post by: Yeshai Bouskila on August 25, 2008, 04:31:13 PM
Thank's H