<![CDATA[PunBB Forums — Possible to combine 2 databases?]]> https://punbb.informer.com/forums/topic/21032/possible-to-combine-2-databases/ Fri, 13 Feb 2009 00:13:17 +0000 PunBB <![CDATA[Re: Possible to combine 2 databases?]]> https://punbb.informer.com/forums/post/124523/#p124523 i am already doing this
it is easy
the forumid and topicid and postid
should not intersect you have to make iterations in 1 of the boards
how  to make iterations ? example is below i am not sure the table names are correct you have to confirm it.
UPDATE forum
SET forumid=forumid+1289;

UPDATE thread
SET threadid=threadid+450000;
UPDATE thread
SET forumid=forumid+1289;

  UPDATE post
SET postid=postid+2400000;
UPDATE post
SET threadid=threadid+450000;

you will have to create new forums matching  forum id on your 2nd forum which you are closeing

mysqldump -u dbuser -p[pwd] --no-create-db --no-create-info database2nd > database_backup.sql
mysql -u dbuser -p[pwd]  database1st < database_backup.sql

]]> Fri, 13 Feb 2009 00:13:17 +0000 https://punbb.informer.com/forums/post/124523/#p124523 <![CDATA[Re: Possible to combine 2 databases?]]> https://punbb.informer.com/forums/post/124429/#p124429 Lots of good ideas, thanks!  Would it be possible to just go into configuration and change where  the new, empty board points, change the config so the second board uses the same database?  Would that cover it?

]]> Wed, 11 Feb 2009 02:07:25 +0000 https://punbb.informer.com/forums/post/124429/#p124429 <![CDATA[Re: Possible to combine 2 databases?]]> https://punbb.informer.com/forums/post/124084/#p124084 The way this is possible is:

  • Have the both forums within the same table, but different prefix's

  • Create a script (which would be too hard) that will do for each row, insert it into the new db. You would have to do this for Users

It wouldnt be possible for Forums/Topics/Posts as the foreign keys will change and wont work.

]]> Wed, 04 Feb 2009 12:22:50 +0000 https://punbb.informer.com/forums/post/124084/#p124084 <![CDATA[Re: Possible to combine 2 databases?]]> https://punbb.informer.com/forums/post/124078/#p124078 that's hard to do.perhaps given up one.

]]> Wed, 04 Feb 2009 11:36:15 +0000 https://punbb.informer.com/forums/post/124078/#p124078 <![CDATA[Re: Possible to combine 2 databases?]]> https://punbb.informer.com/forums/post/124046/#p124046 Export it. Then import it into the other one. PhpMyAdmin can do this easily. But you should be sure that there are no double entries (like two users with the same name or something like that)! Double entries could lead to problems.

]]> Tue, 03 Feb 2009 16:37:10 +0000 https://punbb.informer.com/forums/post/124046/#p124046 <![CDATA[Possible to combine 2 databases?]]> https://punbb.informer.com/forums/post/123958/#p123958 Say I have two message boards, very similar, and want to close one down but want to move all the people/forums/topics etc to my other board.

Can I somehow incorporate the one database into the second database? Is this possible?

]]> Sun, 01 Feb 2009 20:26:05 +0000 https://punbb.informer.com/forums/post/123958/#p123958