Database

[Daniel Muñoz]

Hey guys, I need to extract from a database tables.

users
topics
comments
forums
subforums
categories

Since I want to add these tables to another database.

[Wayne Luke]

There are no distinct tables for topics, comments, forums, subforums, and categories. All of these are stored in the node* tables with additional tables joined in. These tables include channels (all channels including forums and subforums), text (topic, reply and comment text for all nodes). Everything is tied together with the closure table which stores the node ids of everything as well as the node id of every parent of that item.

You're best off looking at the API code and pulling information via nodes and then putting it in tables you want on your other database.

The user record is basically stored in the user, usertextfield and userfield tables.