In the node table, you'll find everything EXCEPT the actual body. Where can I find this body text? I'm assuming it's being stored as a blob somewhere.
+9
A:
I don't have a running drupal installation here, but I asked myself this very a couple of weeks ago -- and it took time to find the answer :-D
If I remember correctly, the body of the node is stored in the table that is used to keep the "revisions" of the node.
Not sure what it's name is, but it's gotta be something like node_revision or node_revisions
Ah! Here is a link that might be useful : http://webdevgeeks.com/schemaspy/tables/node%5Frevisions.html
Pascal MARTIN
2009-08-16 14:58:41
correct. it's `node_revisions`.body
Rosarch
2009-08-16 15:00:50
Just to add... the purpose of separating the body of the node is to allow the devs to create as many different content types as they want and have just one table containing all the node_id's. Revisions, which include the body, are on separate table(s).
Randell
2009-08-16 15:02:36