PDA

View Full Version : Database Editing?


spillage
05-31-2009, 12:20 PM
Can site content (posts) be edited within the database directly?

What software do you recommend for database editing?
I've seen RazorSQL, Navicat, dbForge, iSQL-Viewer, to mention a few.

The reason I ask is, I have a small sub forum (less than 100 posts) on an old Drupal site that didn't import, and I want to recover the posts and merge them into the new vB forum.

No matter what I tried, IMPEX did not get the sub forum and it's content that is 3 deep (Category/Forum/Sub Forum).

Dismounted
06-01-2009, 05:16 AM
You shouldn't directly edit tables, as there may be other things you need to do (i.e. add entry in thread table, refresh cache, etc.).

You can create a PHP script that inserts threads with build_new_post(), or the data manager.

spillage
08-22-2009, 03:31 PM
This request is not really to insert the posts, as I can do that manually by making a new post and changing the user name.
What I want to do is recover the post text directly from the old database, as the Drupal forum has died and is not accessible, even as an Admin.