Convert One YG board to SE?

[UnkaBobby]

[font="Trebuchet MS"]
Can anyone suggest a way to convert one board from a Yabb Gold installation, to a YabbSE installation?

Meaning, insert the threads of a single board from a YG forum, into an up-and-running YabbSE forum?

Would be a HUGE help, any ideas welcome, I'm new to MySQL but a long-time programmer/etc.


Thank you!
Bobby


[/font]

[Omar Bazavilvazo]

http://www.yabbse.org/community/index.php?board=132;action=display;threadid=15629
http://www.yabbse.org/community/index.php?board=132;action=display;threadid=18377

ja ne!

[Compuart]

Can anyone suggest a way to convert one board from a Yabb Gold installation, to a YabbSE installation?

You'd have to make a lot of modifications to the converter to grab a specific board an put it into an existing YaBB SE install.

[Spaceman-Spiff]

better way, i think, is to convert everything, then delete the other boards

[UnkaBobby]

better way, i think, is to convert everything, then delete the other boards

[font="Trebuchet MS"]
Thank you experts for the time you take to reply to us.

Okay, more succinctly, what I desperately need to do is insert a board from one forum, into another forum.

Following your advice that doing it from a YG forum into an SE forum would be too hard, I converted the YG forum to SE.

So, I have two SE forums now on the same server, sharing the same MySQL database.

I desperately need to move a board from one of them, into the other.

With phpMyAdmin, I see I can export a table (such as the BOARDS and MESSAGES tables) to a textfile. I can't find the feature to *import* data from a textfile, into a MySQL table.

Can anyone advise me about completing this safely, though? If I have a forum with MySQL prefix "GI_", need to insert the boards and messages from another SE forum with MySQL prefix "RAW_"...?


Hugely appreciative of any advice,
Bobby


[/font]

[[Unknown]]

Alright, it's going to be fun.

Here's the process.

Get the text files, and look for the inserts.  (remove ANYTHING that doesn't start with # or INSERT... specifically, remove DROP and/or CREATE!)  You should see something as follows:
INSERT INTO prefix_topics VALUES (213, ......);

Remove that first number, and replace it with NULL.... so it should look like:
INSERT INTO prefix_topics VALUES (NULL, ......);

Do the same for lines that look like this:
INSERT INTO prefix_messages VALUES (NULL, ......);

Now do a search and replace for all the prefix_ and change them to your SE board's prefix. (the one you want to have the table in.)

Go into phpMyAdmin, and select the SQL tab.  Click on use file, and select that one.  Then, click Go.

That should be it.  Fun, huh?

[edit: You will most ASSUREDLY want to do a board repair and recount after doing this.]

-[Unknown]

[raffael3d]

I successfully converted from Yabb Sp.1.1 to Yabb SE. now I noticed several things taht are problems or not working fine:

- the new fader: the text doesn't fade even with multiple entries
- global moderators don't see IP of posted people (they should be able to see it like In Yabb otherwise they are not helpful as moderators)
- altough the member count is right the first person that was converted is displayes as "last registered member", even if new people register it doesn't update taht
- if you activate that people will have their password emailed they never get it...

any help?thanks.