Urgent - Help/advice needed (MySQL related tasks) in forum data salvation

[oldtima]

I am a member of TV Tome, and against the recent changes foreboding the domain into a horrible merger which has policies which in the end negate the users who've built the site from having any say in the matter. While the webmaster gets all monetary benefits of the merger from a potentially free-non-profit founded site. With that all aside I want to know if this data can be salvaged by being ported over into a ProBoards (which is the new horrible forum system on the merge site) forum by way of a script or tool? Since they say they're going to wipe all the forum data (which has countless user opinions). I've searched and searched, couldn't find any conversion scripts.

Is this even possible?

Thanks for all help. Urgency is of the essence.

I was told the forum was SQL - Here's an example: http://tvtome.com/tvtome/servlet/GeneralForumThread/forumid-90/

[Tangerine Dream]

I was told the forum was SQL - Here's an example: http://tvtome.com/tvtome/servlet/Ge...ead/forumid-90/
Hi, i followed your posted link and didn't find any MySQL related issues. You need to state your problem as a set of MySQL related tasks :)

[oldtima]

Advice for which exact area to post it. Thanks. Also can I get a mod to move it to the correct area?

Per the task comment: I had a iffy feeling it was actually SQL. I knew it was a mix of things.

[Tangerine Dream]

Try Report this post and ask moderators to move your thread to the forum you want (Other Databases, PHP or ASP). Good luck

[NancyJ]

First off, do you have access to the sql databases?

It is possible to convert forums from one format to another but it helps to have access to the data or at least the table and field names.

The first thing you would need to do is convert all your forum members to being memebers of the new forum as each post in a forum is usually asigned a member id so you know who posted the message.

After converting all the members you would have to move the posts.

I did this recently for a client so its still fresh in my head ;)

What I did was first determine which messages were the topic and for each topic look up member ID in the old db and extract their email address then match it with the new db and extract the member ID to attribute to the post (and insert into the db), then look for any replies to the topic (linked by ID number) and do the same look up for the members and then insert them into the database linking the new ID number from the topic.

its quite difficult to get your head round and you do need to know the forum db's inside out pretty much but thats the basics of the process