You can use this query:

UPDATE gforum_Post set forum_id_fk = 123 WHERE forum_id_fk = 456

Replacing 123 with the new forum, and 456 with the old forum. You may get results a little bit screwed up in the forum listings - the latest post information may be wrong; an easy way to fix this is to post into each forum, then delete (full delete - ie. "Remove") those two.

You could do this using Gossamer Forum code (from a global, plugin, new CGI script, etc.) by doing:

$DB->table('Post')->update({ forum_id_fk => 123 } => { forum_id_fk => 456 });

Doing it this way you won't have to worry about the forum display being messed up - but it's more effort since you'll have to put the code somewhere for it to run.

---

Jason Rhinelander
Gossamer Threads
jason@gossamer-threads.com