View Single Post
  #2 (permalink)  
Old 06-21-09, 01:25
gazzie gazzie is offline
BOD Member
 
Join Date: Jun 2009
Posts: 65
Default

If the blog and forum use different table prefixes (and they probably do), then splitting the database is easy. Simply do the following:

1. Go to phpMyAdmin, and select the database you want to modify.
2. Click Export.
3. In the export box, select the database tables for the blog (Wordpress usually uses the wp_ suffix). Make sure the SQL radio button is selected.
4. Scroll down and check the "Save as file" checkbox. Give the file a name, select compression type, then click Go.

And that's it. Just repeat the process for the forum tables.
Reply With Quote