Double database

The -L- · September 12, 2009, 12:12:25 PM

Hello...could you make me this little clearer

I have a forum with its database of course. I want to make another forum on my host that will have SAME database BUT a copy of it...so ALL topic,posts and members to be the same. BUT i want to erase some topic witch is un needed on second one...but i want to keep them on original forum...help me with this...

Like:
1.Original Database (Untouched)
+
2.Copy Of Database (edited)

Kill Em All · September 12, 2009, 12:19:38 PM

I'm actually in the process of doing this same thing. What I'm doing is creating back ups of my current database then uploading the tables to a new database. Having the same database on the same server can cause trouble between both of them.

The -L- · September 12, 2009, 12:30:38 PM

If names are different then it shouldn`t be a problem and if i edit posts and merge topics then it wont be the same...

So any answers?

Kill Em All · September 12, 2009, 12:50:32 PM

As long as the names of the two databases are different. Correct.

The -L- · September 12, 2009, 12:59:24 PM

Ok now that we know all that can you make me clealer all this...i mean how to make copy of database and change its name...(i know how to do backup but idk if its the same...) and how to establish it on other forum...:d

Kill Em All · September 12, 2009, 05:56:23 PM

Well what I did was copy all my current SMF files to a new directory. I backed up the database, changed the name a little. Uploaded my database, using cpanel. Then I uploaded repair_settings.php to that directory, changed the needed info such as the database info, directories... Look at these links for any help you need.
What is repair_settings.php?
How do I restore a database backup?
How do I backup my database?

That should be all you need really.

The -L- · September 12, 2009, 06:16:50 PM

Now that i think a bit...i need to all my members be members on both forums...cause i dont want for guests to see links and i want for moderators to moderate (and registration would be needed twice -.-). So i need those databases connected witch is i guess impossible......

Idk can i make hidden category on forum that can be seen just via link???
Or something similar?

Arantor · September 12, 2009, 07:38:57 PM

What are you trying to achieve, exactly?

If you want two forums with the same members, but different boards, you'll have to get into the realms of merging databases and modifying the code - which is no small task.

The -L- · September 12, 2009, 07:42:25 PM

I basically want to split board at 2 forums... but i want it to have same database as when someone registers on one he is automatically registered at other one...

Or if there is simpler solution...

Arantor · September 12, 2009, 07:52:36 PM

There are various solutions.

I'm still not clear on the necessity of the divide - depending on what you're trying to achieve there are many different ways to do it.

The -L- · September 12, 2009, 08:09:01 PM

Like what?

I just wanna separate two categories into 2 same forums...(ofc if its possible)

Arantor · September 12, 2009, 08:47:44 PM

Oh, it's possible. But I'm trying to establish the logic behind it. Separating two categories into two forums that utilise the same logins is a HUGE amount of work, especially if you want to keep certain divides between them such as independent post counts, plus things like single-sign on (i.e. login on one logs you in on both)

Remember, you can have different themes at board level, so it would be possible to make it look and feel like two distinct sites whilst having only one structure in place.

And if you have these two across two domains, it suddenly gets even more complex. Not to mention if the two are on different servers.

The -L- · September 13, 2009, 06:22:36 AM

No no no,its on one domain xD

Is it possible to make hidden category or sub forum on forum? (And access can be established just over link)
And is it possible to that hidden cat/sub has its own nav bar (different then the others)?

Arantor · September 13, 2009, 09:52:52 AM

You can hide category/forum/subforum based on usergroup (but that limits access)

If you just want to hide it that's going to be a custom modification to BoardIndex.php.

As for custom navbar, that's easy; you can assign a different theme (which can include navbar) to every board if you like.

The -L- · September 13, 2009, 10:00:38 AM

QuoteYou can hide category/forum/subforum based on usergroup (but that limits access)

Can i do this without limiting access? Like to subforum dont get listed and still can be accessed via something like
www.forum.com/index.php?topic=336177.new;topicseen#new

Arantor · September 13, 2009, 10:12:40 AM

Quote from: Arantor on September 13, 2009, 09:52:52 AM
If you just want to hide it that's going to be a custom modification to BoardIndex.php.

The -L- · September 13, 2009, 10:37:41 AM

Hmm...can you show me more info...like what to search for and with what to replace in code...

Arantor · September 13, 2009, 10:44:51 AM

Not really because it's not a simple find/replace job.

It's a series of changes depending on the number and types of boards, possibly also changes to BoardIndex.template.php too.

The -L- · September 13, 2009, 10:52:28 AM

Nah then i wouldn`t mess with it...

The -L- · September 14, 2009, 06:52:01 PM

My good friend is mysql and php expert he runs really great sites...he told me that its possible to do what i want he told that database is file that contains everything from user accounts to board data and all info and settings...he told that in forum index board file there is command that calls a list of boards out from my database witch part is named "forum"...he told that if i split "forum" part of database and name the other half "forum2" i could call it from other forum so original forum use just "forum" part of database and other forum i want to make would use "forum2" part of database...

Could this be done?

News:

Double database